Hi, never amend T24 file from a back-end unless you're absolutely sure what you're doing...
Instead use OFS. VK On May 29, 3:10 am, Jim Idle <[email protected]> wrote: > Jose L wrote:Hi Jim, Thank you for your help. I know I can use JED, but I'd > like to update a large number of records (about 300,000), and definitely I > don't want to do it automatically. How can I use SQL in Jbase? You say I need > to have the file defined? defined where and how?For a one off operation, that > is way more work than you could possibly want to do. > Why not write a small jBC program? You could have written and run it by now > ;-) Or, if you are feeling adventurous and dangerous, learn about the P > command in ED. > t.b > OPEN "File" TO File ELSE ABORT 201, "File" > LOOP WHILE READNEXT ID DO > READ Rec FROM File, ID ELSE CONTINUE > Rec<7> = "" ;* Replace 7 with correct attr or a reference to SENTENCE > WRITE Rec on FILE ID > REPEAT > jcompile t.b -o t > SELECT File WITH etc. etc. > 300,000 Records selected > >./t > JimThank you very much. Jose On 28 mayo, 18:40, Jim > Idle<[email protected]>wrote:Jose L wrote:Hi, Is there any way to > update a record using a command in jShell? Something like this:UPDATE > F.SECURITY.MASTER SET RATING = ''I think that was using their command line > SQL stuff.> In Universe it was possible, but in Jbase it says:jsh miasmi01 ~ > -->UPDATE F.SECURITY.MASTER SET RATING = '' Error in Statement "UPDATE > F.SECURITY.MASTER SET RATING = ''" Parse Error: ..Someone knows how to do > it?jed F.SECURITY.MASTER recordId Change the attribute you need (CT DICT > F.SECURITY.MASTER RATING to find out which attribute).This the information > from out Jbase version.RELEASE Information : Major 4.1 , Minor 5.17 , > Patch 5690 (Change 52756)You may have command line SQL available, but it > won't help unless the file is defined and so on I think. Jim --~--~---------~--~----~------------~-------~--~----~ Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en -~----------~----~----~----~------~----~------~--~---
