Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

While Binding DBB program using the BIND jcl result in SQLCODE:000000080N #36

Open
Nagaraj1995 opened this issue Jul 13, 2020 · 1 comment

Comments

@Nagaraj1995
Copy link

Due to some reason , we have provided bind property as false in Bind properties and tried to bind the DBB compiled program using BIND jcl which uses the PLAN. Here even though the program changes are not made for Db2 it throwing SQL error if it's not bind and after binding also it not making any changes to Db2 but program is running, is there anything specific we need to provide here for binding DBB programs ?
JCL we used for compilation:

//SYSTSIN DD *
DSN SYSTEM(DBXX)
BIND PLAN(CBXX) MEMBER(CBDBBB) -
LIBRARY ('DBB.OLD.DBRM') -
ACTION (REPLACE), VALIDATE(RUN), ISOLATION (CS) , FLAG (I), -
ACQUIRE (USE) , RELEASE (COMMIT) , EXPLAIN (NO), RETAIN, -
OWNER(COREBK) , QUALIFIER(COREBK), ENCODING(EBCDIC)
END

Please help us to bind the program which will reflect the Db2 changes

@dennis-behm
Copy link
Member

Apologies, but it is hard to understand your issue.
000000080N is a -805 which means that this is a bind issue.

Do you see the program and DBRM generated for your particular program source in the dbb build report?
Do you would like to run the Bind step as part of the dbb build or do you would like to do that after the deployment to the target environment?
Have you made sure, that you are using the correct libraries in the Bind step?

I think it would be wise, to reach out to your Db2 admins to work on that issue.

johnmnemec pushed a commit to johnmnemec/dbb that referenced this issue Sep 6, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants