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?
Thank 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 -~----------~----~----~----~------~----~------~--~---
