IBM MAINFRAME HELP FORUMS for COBOL, JCL, CICS, DB2, IMS etc...
Help & Support Forums for IBM Mainframe computers Applications like COBOL, JCL, CICS, DB2, FileAid, DFSORT, Endevor, Xpediter, CoolGen, CA-7, CA-11, AbendAid, IMS, IDMS, PL/I, MqSeries, SyncSort, Assembler, VSAM, ISPF, ChangeMan, Easytrieve, InterTest, REXX, CLIST etc...
 

sqlcode +354

THIS IS AN ARCHIVE FORUM: CLICK HERE TO GO TO THE ORIGINAL TOPIC

 
       IBMMAINFRAMES.com - IBM Mainframe Support Forums Index -> DB2
View previous topic :: View next topic  
Author Message
sanjue



Joined: 03 Jul 2008
Posts: 1
Location: Chennai

Posted: Tue Jul 08, 2008 12:06 pm    Post subject: sqlcode +354  

What are the fixes to be done incase of an occurence of SQLCODE +354.This was obtained while trying to do a multi row fetch.
Back to top  
ascelepius



Joined: 16 Jun 2008
Posts: 35
Location: bangalore

Posted: Tue Jul 08, 2008 2:13 pm    Post subject: Reply to: sqlcode +354  

Hi sanjue,

Its always better to use "GET DIAGNOSTICS" when you use muti-fetch and multi-insert qeuries. Since you have not mentioned any details about How or When you got this warning, it will be not be possible to give you any info on Why u got this error.

But for more info look here and the SQL error description
Back to top  
rpuhlman



Joined: 11 Jun 2007
Posts: 70
Location: Columbus, Ohio

Posted: Tue Jul 08, 2008 3:09 pm    Post subject:  

Sanjue,

Try this also:

http://publibfp.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/dsnc1j12/2.2.26?ACTION=MATCHES&REQUEST=%2B354&TYPE=FUZZY&SHELF=&DT=20070111144235&CASE=&searchTopic=TOPIC&searchText=TEXT&searchIndex=INDEX&rank=RANK&ScrollTOP=FIRSTHIT#FIRSTHIT

Rick
Back to top  
 
       IBMMAINFRAMES.com - IBM Mainframe Support Forums Index -> DB2
Page 1 of 1
THIS IS AN ARCIVE FORUM IN READ ONLY MODE. IF YOU WANT TO ASK YOUR DOUBTS USE THE ACTUAL FORUM
Related Links