Please explain this SQL CODE.

tamminenisidhartha · New User Joined: 31 Oct 2012 Posts: 43 Location: INDIA

Hi all,
I am trying to create a package.
But I am getting SQLCODE = -206.
I have gone through this link: pic.dhe.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z9.doc.codes%2Fsrc%2Ftpc%2Fdb2z_sqlcodes.htm

But I could understand what I should correct.

Could anyone please explain why the error actually occurs ?

The step abending is

//STEP5 EXEC PGM=IKJEFT01
//DBRMLIB DD DSN=FSS310.HRIT.DBRM,DISP=SHR
//STEPLIB DD DSN=SYS1.DSNDBZ.SDSNLOAD,DISP=SHR
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSIN DD *
/*
//SYSTSIN DD *
DSN SYSTEM(DBZ)
BIND PACKAGE(PCKCLL) MEMBER(MIT001) -
LIBRARY('FSS310.HRIT.DBRM') -
ACTION(ADD) -
OWNER(EXT99) -
QUALIFIER(EXT99) -
VALIDATE(BIND) -
ISOLATION(CS) ENABLE(*)
END
/*

tamminenisidhartha · New User Joined: 31 Oct 2012 Posts: 43 Location: INDIA

The problem is solved.
Please don't reply.

Thank you all.

Anuj Dhawan · Posted: Wed Mar 13, 2013 6:19 pm

Thanks for the follow up, however, it'd be nice if you can share the solution you've used.

tamminenisidhartha · New User Joined: 31 Oct 2012 Posts: 43 Location: INDIA

@Anuj Dhawan
The table we are trying to access, doesn't exist.
So we created a table and then executed the step mentioned above in the topic.
It is executing successfully now.

Pandora-Box · Posted: Thu Mar 14, 2013 3:43 pm

So why did you get -206 ? You should have got -204