MVSFORUMS.com

kolusu · Posted: Fri Aug 18, 2006 6:05 am Post subject:

js01,

Looks like status is either an Integer or Decimal field. So it is unloaded but it is not in displayable format. You need to use DIGITS or CHAR function to see it in displayable format. Spufi automatically reformats the data for you. Look at the SYSPUNCH output in sysout and it will list all the columns unloaded and their position in the output dataset.

Shekar123,

It does not matter how many times the status value is repeated in the IN clause. on the SQL. DB2 looks as it as Long list of variables and selects all the rows satisfying the conditions mentioned treating the values as embedded OR condition

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

js01 · Posted: Fri Aug 18, 2006 7:40 pm Post subject:

Sekhar/kolusu,

Yes! i could see the field in SYSPUNCH ,and dispalyed when i use CHAR function thank you very much.

Other question:

What is the maximum length of the SELECT query that we can execute
actually when I try to execute above query thru spufi with input as 500 line (IN clause) got an error saying that length is exceeded

thanks in advance.

coolman · Posted: Sat Aug 19, 2006 1:13 pm Post subject:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNSQH11/A.0?DT=20010718164132
________
easy vape vaporizer

js01 · Posted: Mon Aug 21, 2006 6:43 pm Post subject:

Thank you Coolman