View previous topic :: View next topic
|
Author |
Message |
Judy85
New User
Joined: 05 Aug 2011 Posts: 17 Location: China
|
|
|
|
What is the reason for SQLCODE = -311 when unloading a table with SQL?
Code: |
//SYSTSIN DD *
DSN SYSTEM(DB2D)
RUN PROGRAM(DSNTIAUL) PLAN(DSNTIAUL) PARMS('SQL') -
LIB('DB2D.RUNLIB.LOAD')
//SYSIN DD *
SELECT MACH_TYPE,SERIAL_NBR,CUST_ADDR
FROM LIDS.DWCC
WHERE CUST_ADDR LIKE '%DEPT OF ENERGY%'
OR CUST_ADDR LIKE '%ARMY%'
OR CUST_ADDR LIKE '%NAVY%'
OR CUST_ADDR LIKE '%AIRFORCE%'
OR CUST_ADDR LIKE '%FDIC%'
OR CUST_ADDR LIKE '%REPUBLIC BANK%'
OR CUST_ADDR LIKE '%DEPT OF DEFENCE%'
OR CUST_ADDR LIKE '%FBI%'
OR CUST_ADDR LIKE '%IGOV%'
OR CUST_ADDR LIKE '%MARINE CORP%'
OR CUST_ADDR LIKE '%US MARINES%'
OR CUST_ADDR LIKE '%US SENATE%'
OR CUST_ADDR LIKE '%US TRUSTEES%'
OR CUST_ADDR LIKE '%USDA FSIS%'
OR CUST_ADDR LIKE '%USDA-ARS-PDL%'
OR CUST_ADDR LIKE '%VIEJAS%'
OR CUST_ADDR LIKE '%VION CORP%'
OR CUST_ADDR LIKE '%VISTRONIX INC%'
OR CUST_ADDR LIKE '%VITRO SVCS DIV%'
OR CUST_ADDR LIKE '%WILDWOOD%'
OR CUST_ADDR LIKE '%WINCOR NIXDORF%'
OR CUST_ADDR LIKE '%WORLD BANK%'
OR CUST_ADDR LIKE '%101ST AIRBORNE DIV%'
OR CUST_ADDR LIKE '%3D RESEARCH CORP%'
OR CUST_ADDR LIKE '%53 SPTS/SCN%'
OR CUST_ADDR LIKE '%6TH CIRCUIT%';
/* |
|
|
Back to top |
|
|
Escapa
Senior Member
Joined: 16 Feb 2007 Posts: 1399 Location: IL, USA
|
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
one of your literals is greater than the length of CUST_ADDR
-311 explained here
and why are you (I assume you are a chinese company) doing looking at databases with US Military info? |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hi DIck,
We (US - DoD) contract anywhere . . .
d |
|
Back to top |
|
|
Judy85
New User
Joined: 05 Aug 2011 Posts: 17 Location: China
|
|
|
|
I fact, I am in Us company. |
|
Back to top |
|
|
Judy85
New User
Joined: 05 Aug 2011 Posts: 17 Location: China
|
|
|
|
CUST_ADDR is 120 CHAR
Code: |
Select Column Name Col No Col Type Length Scale Null Def FP Col Card
* * * * * * * * *
------ ------------------ ------ -------- ------ ------ ---- --- -- -----------
SERV_PERF 11 CHAR 1 0 Y N N -1
CUST_ADDR 12 VARCHAR 120 0 Y N N -1
DLR_CMT 13 CHAR 90 0 Y N N -1
PART_QTY 14 INTEGER 4 0 Y N N -1 |
|
|
Back to top |
|
|
gylbharat
Active Member
Joined: 31 Jul 2009 Posts: 565 Location: Bangalore
|
|
|
|
Can you post the entire error message? |
|
Back to top |
|
|
Judy85
New User
Joined: 05 Aug 2011 Posts: 17 Location: China
|
|
|
|
I have found the problem. It is because of the problem of the numbers from column 73 to 80 in JCL dataset. I have fix the problem by deleting the numbers. Thank you all! |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
You're welcome.
Good to hear it is working - thank you for letting us know
d |
|
Back to top |
|
|
|