Anybody happen to know the character limit for the statement in the SYSTEM() command?
Ex., Given
#RC = SYSTEM(statement )
how long can statement be?
Thanks,
~G
Click the link below to see the new game I'm developing!
5 replies to this topic
#2
Guest_Joseph V.G. Orendain_*
Guest_Joseph V.G. Orendain_*
-
- Guests
Posted 26 April 2005 - 09:02 PM
I think it depends on the command you are running and on which os.
When I used this command, I basically use a scratch variable to define the statemen to run. When you do this, make sure you define the size of $var if it is more than 30 or used $$. So far the longest statement I ran with this command is about 40 chars (I did it in unix....called a script to cat parameters and pipe the results to another command)
Hope this helps...
Joseph
When I used this command, I basically use a scratch variable to define the statemen to run. When you do this, make sure you define the size of $var if it is more than 30 or used $$. So far the longest statement I ran with this command is about 40 chars (I did it in unix....called a script to cat parameters and pipe the results to another command)
Hope this helps...
Joseph
#4
twallis
-
- Members
-
- 19 posts
Member
- Gender:Male
- Location:Edinburgh
Posted 03 May 2005 - 04:27 AM
I usually crank it up to 250.
Just as well you don't go any higher while the variable can store more than this some commands cut off the end. While I have not tested this on the SYSTEM command, I know that on the SYS-SQL command it does not take any more than 250 characters.
#6
twallis
-
- Members
-
- 19 posts
Member
- Gender:Male
- Location:Edinburgh
Posted 04 May 2005 - 01:09 AM
I have gotten around it by saving the data as views in oracle or a batch type of file.
This becomes a little difficult to follow so not the best way to code.
It does always get the correct result so up to you.
This becomes a little difficult to follow so not the best way to code.
It does always get the correct result so up to you.
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users
Click the link below to see the new game I'm developing!
