Re: Update from jShell

[Jim Idle]

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 Jim Thank you very much. Jose On 28 mayo, 18:40, Jim Idle <j...@temporal-wave.com> 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 jBASE@googlegroups.com To unsubscribe, send email to jbase-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/jBASE?hl=en -~----------~----~----~----~------~----~------~--~---