why we go for SPUFI for creating tables or for sql queries?
Answer Posted / satty
becoz spufi is interactive and spontaneous which makes user
to create faster and allows user to know whats wrong when
there is error.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is bind in db2?
How many databases are there?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Where can you declare a cursor in a cobol-db2 program?
How does coalesce work?
What is copy pending and check pending in db2?
What is the difference between nvl and coalesce?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
How to fetch the last row from the table in SQL (db2)?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What is the use of with ur in db2?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
How do I add a column to a table in db2?