Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain how can you do the explain of a dynamic sql statement?

1062


SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11612


What action db2 takes when a program aborts in the middle of a transaction?

1087


What is the difference between cursor and select statement?

1051


can all users have the privilage to use the sql statement select * (dml)?

1102


What is dpf in db2?

1047


Explain what are the various isolation levels possible?

988


What is universal database?

1029


Which is faster delete or truncate?

1068


Describe major components of db2?

1039


What is the difference between cursor stability and repeatable read isolation levels?

1113


What is null indicator in db2?

1049


What is the syntax for creating a table in the db2 database?

1055


List out the buffer pools in db2

1018


What is runstats and reorg in db2?

1236