IDS 9.4 - LOAD in SPL
Reyna Sabina asked whether the LOAD statement is allowed in SPL on IDS 9.4. June C. Hunt said no and pointed to the SQL manuals; Jean Sagi agreed and suggested using SYSTEM to run an OS script that runs an unload; Sergei Moisseyev said it never will be. Answer: not supported.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hello, Is the LOAD statment (used in DBAcess) allow in SPL? Thanks in advance for your reply! Reyna _________________________________________________________ Reyna Sabina Phone: (305) 361-4324 NOAA/AOML/PHOD Fax: (305) 361-4392 4301 Rickenbacker Causeway Email: Reyna.Sabina@noaa.gov Miami, FL 33149-1087 "Things do not get better by being left alone." -Winston Churchill
Reyna Sabina wrote: >Hello, > > Is the LOAD statment (used in DBAcess) allow in SPL? No, it is not. See the the Guide to SQL: Syntax and Tutorial manuals at the link below. Chapter 3 of the syntax guide, and Chapter 11 of the tutorial discuss the commands that are allowed. http://www.ibm.com/informix/pubs/library/lists.html -- June Hunt
No it isn't supported, AFIAK... However you could use SYSTEM to run a o.s. script wich runs sql query with an unload. Chucho! -----Original Message----- From: "Reyna Sabina" <Reyna.Sabina@noaa.gov> To: ids@iiug.org Date: Wed, 28 Jul 2004 11:22:53 -0400 (EDT) Subject: IDS 9.4 - LOAD in SPL [3298] Hello, Is the LOAD statment (used in DBAcess) allow in SPL? Thanks in advance for your reply! Reyna _________________________________________________________ Reyna Sabina Phone: (305) 361-4324 NOAA/AOML/PHOD Fax: (305) 361-4392 4301 Rickenbacker Causeway Email: Reyna.Sabina@noaa.gov Miami, FL 33149-1087 "Things do not get better by being left alone." -Winston Churchill Jean Sagi jeansagi@myrealbox.com jeansagi@yahoo.com
Seems it is not! And never will be available here > Hello, > > Is the LOAD statment (used in DBAcess) allow in SPL? > > Thanks in advance for your reply! > > Reyna > _________________________________________________________ > Reyna Sabina Phone: (305) 361-4324 > NOAA/AOML/PHOD Fax: (305) 361-4392 > 4301 Rickenbacker Causeway Email: Reyna.Sabina@noaa.gov > Miami, FL 33149-1087 > > "Things do not get better by being left alone." > > -Winston Churchill > > ----------------------------------------- ITV - Sinu lemmiksaated internetis! http://www.itv.ee