Interested to Buy Any Domain ? << Click Here >> for more details...
i hav created a program and moved to production but failed
to create the table which is been used in the program. the
program shows error as soon as it is moved or installed in
production or shows error during its runtime. what is the
sqlcode for this error
- 3 Answers
- 7253 Views
- UST, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / andank
The code promotion will fail. When you promote the code
from one region to other (say QC to Production), the
program will be bound (BIND) to the new DB2 environment.
The BIND will fail with SQLCODE of -204 (Object Not found).
The code will not be moved to production successfully and
there is no chance of 'runtime' error.
| Is This Answer Correct ? | 14 Yes | 0 No |
Answer / nitin
If the table is missing then you will get sql code -204.
You will get -204 while binding if you specify the bind
parameter validation(bind) and you will get the -204 at
run time( bind will run sucessfully) if you specify the
bind oparameter as validatin(run).
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / mahesh
it will Abend with SQLCODE=-922(Authoriziation issue); as
while promotion to production ; it wont allow the tables
created in test region.
Please correct me if i am wrong ?
| Is This Answer Correct ? | 0 Yes | 7 No |
List down the types of triggers in the db2 database?
how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...
Can we use select * statement in cobol program without giving field names ???
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
How do you run JCL in cobol program
How do I copy a table in db2?
What is a thread?
What is DCLGEN ?
What is declare cursor?
What does it mean if the null indicator has -1, 0, -2?
One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
What is the syntax of SELECT statement when embedded in a COBOL program?
COBOL 
