Db2 Error Dsnt408i Sqlcode
Contents |
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic db2 code Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory
Sqlcode 924
TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries Inside-ERP MacProTX VoIP_News Inside-CRM PCMag I_am_the_dragon maxwellarnold Michael Meyers-Jouan
Sqlcode 811
TerryCurran Chris_Day Andrew.S.Baker JoeTorre bracke Locutus Ramnath.Awate Richard DukeGanote Craig Borysowich Dennis Stevenson Nikki Klein mircea_luca AbhaiTripathi knowscognosdoi bluesguyAZ59 Iqbalyk Clinton Jones blrvenkat COMPANIES Juniper Networks CloudLock Avaya Adaptive Planning View All Topics http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/codes/src/tpc/n922.html View All Members View All Companies Toolbox for IT Topics Database Groups Ask a New Question DB2 LUW The DB2 LUW (Linux, Unix, Windows) group is for the discussion of technical issues related to the installation, configuration, or daily administration of IBM DB2 LUW databases. Home | Invite Peers | More Database Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create http://database.ittoolbox.com/groups/technical-functional/db2-l/how-to-resolve-dsnt408i-sqlcode-922-error-5385111 your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. How to Resolve DSNT408I SQLCODE = -922 Error Santa asked Dec 16, 2013 | Replies (1) While debugging a cobol-db2 program getting DSNT408I SQLCODE = -922 error when trying to open a cursor. Can anyone suggest a solution? Join this group Popular White Paper On This Topic Self Service Business Intelligence 1Reply Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Angelo Sironi replied Dec 16, 2013 Hi Santa, I guess you get the error while trying to conenct to DB2 for z/OS. If that's the case, you should use the DB2 for z/OS thread and not the DB2 for LUW one. You should also tell us the DB2 Version and Release level. If y
help? Post your question and get tips & solutions from a community of https://bytes.com/topic/db2/answers/578322-help-me-solve-dsnt408i-sqlcode-104-a 418,478 IT Pros & Developers. It's quick & easy. Help me http://www.idug.org/p/fo/et/thread=40638 solve this : DSNT408I SQLCODE = -104 P: 1 saai Hi, I was trying to insert a value into a table at the remote DB2 using the database link. insert into tkhr_dummy@holink2 values (3); It gave the error: ORA-28500: connection from ORACLE to a non-Oracle system db2 sql returned this message: DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "(". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: USER Dec 18 '06 #1 Post Reply Share this Question 1 Reply P: 6 rohit Hi, Check the data type of the column you are inserting into. If it is character the use ('3'); and if it is integer db2 sql error the use(3). I think in your case it is char. Let me know if this solves your problem. Rohit. Jan 3 '07 #2 reply Message Cancel Changes Post your reply Join Now >> Sign in to post your reply or Sign up for a free account. Similar topics Help with stored procedure Need Help on Pro-C DB2 error DSNT408I SQLCODE = -812 collection Id missing is there any genius to solve sqlcode 58005 Not getting sqlcode 100 at end of fetch create procedure problem - db2 8.2.3 (DPF) on AIX - help? help with db2image extender 8.2 Help with stored procedure execution.... dynamic SQL from Hibernate and SQLCODE -301 SQLSTATE / SQLCODE Browse more DB2 Database Questions on Bytes Question stats viewed: 10197 replies: 1 date asked: Dec 18 '06 Follow this discussion BYTES.COM © 2016 Formerly "TheScripts.com" from 2005-2008 About Bytes | Advertise on Bytes | Contact Us Sitemap | DB2 Database Answers Sitemap | DB2 Database Insights Sitemap Follow us to get the Latest Bytes Updates
Events Forums DB2-LDB2-L ArchivesNA ConferenceEMEA Conference Resources BlogsIDUG eBulletinIDUG NewsroomCommunitiesRegional User Groups Articles&Content IDUG Content ArticlesTech ChannelBeginner's BlogDB2 Hot Topics BlogContent LibraryIDUG YouTubePast Conference ContentCodeplace Library GetInvolved Volunteering with IDUGVolunteer PositionsJoin a Regional User GroupBecome an IDUG MentorSponsorship OpportunitiesJoin a CommunitySpeaker Community DSNT408I SQLCODE = -30081 jake anderson DSNT408I SQLCODE = -30081 May 22, 2012 01:16 AM Dear All, As part of the "Steps to configure DB2 for z/OS as DRDA AR to DB2 for LUW as DRDA AS" after completing the first Step 1 using : http://www.redbooks.ibm.com/redbooks/pdfs/sg246952.pdf While binding using step 2 I get the below error message : JCL : //A255209$ JOB MSGCLASS=X,MSGLEVEL=(1,1),CLASS=B, // REGION=0M,NOTIFY=&SYSUID //STEP01 EXEC PGM=IKJEFT01,DYNAMNBR=20 //DBRMLIB DD DSN=DSN101C.DSN1.DBRMLIB.DATA, // DISP=SHR //SYSTSPRT DD SYSOUT=* //SYSPRINT DD SYSOUT=* //SYSTSIN DD * DSN SYSTEM(DSN1) BIND PACKAGE(TEST.DSNESPCS) - MEMBER(DSNESM68) - LIBRARY('SYS1.DB2.V10.SDSNDBRM') - SQLERROR(NOPACKAGE) - ISOLATION(CS) ACTION(REPLACE) - VALIDATE(BIND) /* Error Message : DSNT408I SQLCODE = -30081, ERROR: TCP/IP SOCKETS ::XX.XXX.X.XXX CONNECT 1128 76630291 0000 COMMUNICATIONS ERROR DETECTED. API=, LOCATION=, FUNCTION= ERROR CODES= DSNT233I -DSN1 UNSUCCESSFUL BIND FOR PACKAGE = TEST.DSNESPCS.DSNESM68.() DSN END Could anyone please throw some light on the above error. Regards, Jake Adam Baldwin RE: DSNT408I SQLCODE = -30081 May 22, 2012 03:11 AM (in response to jake anderson) Hi Jake. Have you defined this location in the BSDS? If not, you will need to run a DSNJU003 with the DDF option. I'm not saying that this is your error but it is a possibiloity. Cheers, Adam Adam Baldwin RE: DSNT408I SQLCODE = -30081 May 22, 2012 03:18 AM (in response to jake anderson) Actually, on second thought I doubt that your error would be BSDS related. You'd bemore likely to have a problema at DB2 startup. Have you spoken to your Comms people? Is DDF working for other locations? Cheers, Adam jake anderson RE: DSNT408I SQLCODE = -30081 May 22, 2012 03:45 AM (in response to Adam Baldwin) Hi, To be precise the DDF from DB2 on Z/OS end is up