Interested to Buy Any Domain ? << Click Here >> for more details...
Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?
1 5175If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
6 8954My JCL have five steps & I created new versions of GDG in first step through fourth step & fifth step I was refered Step one GDG version. My JCL got abend at 4th step and how I can restart my JCL Please let me know the answers. //STEP1 EXEC GDG1(+1) DISP=(NEW) //STEP2 EXEC GDG1(+2) DISP=(NEW) //STEP3 EXEC GDG1(+3) DISP=(NEW) //STEP4 EXEC GDG1(+4) DISP=(NEW) //STEP5 EXEC GDG1(+1) DISP=(OLD)
11 58034How many types of parameters are used in JCL and what are mandatory parameters of JOB statement.
IBM,
13 28161why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2
3 9178Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
2 6509In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?
8 19338Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?
6 22695
Can you explain communication area?
What are the retrieval sequences in ims db?
What are the different versions of gdg named?
how to move the records from file to array table. give with code example
What is the use of commit in db2?
I have one ps file in which there are 3 fileds emp_no,emp_name and leave_app.this ps file information give the detail of employee which is going to apply for leave.suppose emp_no=113430,emp_name=ajay,leave_app=1 that means he is going to apply for 1 day leave.and accordingling the table in db2 will be updated means if he has that no of leave in his account then he will get dat leave and updated acc. in table(leave_balance=previous leave present in table-leave_app).Now i want to check whther the updated result is correct or not by comparing the two ps file using IEBCOMPARE or icetool so what is going to be the two ps file and how its is going to be compare.
Explain about find and obtain commands?
Define temporary storage?
If a (+1) generation dataset is created in the first step of a job, how can it be referenced in later steps of the same job for input?
What does the 'ceci:cics' transactions do?
How to access db2 tables in mainframe?
What are the contents of a dclmgen?
What is integrated data dictionary?
What is icm instruction?
example for sub strings ? and refernce modifications whit output pls
