 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 10 matches |
| Author | Message |
|---|---|
 Topic: Things required before declaring a global temporary table? |
|
| siva233 Replies: 1 Views: 828 |
 Forum: Database Posted: Sat Nov 11, 2006 9:51 pm Subject: Things required before declaring a global temporary table? |
| Hi,
I came to know that a temp database needed before using declared GTT, How do I verify one such temp database has been created or not in my subsystem? Thanks Siva |
|
| Topic: can we specify keys for a db2 temporary table ? |
|
| siva233 Replies: 1 Views: 1093 |
Forum: Database Posted: Sat Sep 16, 2006 2:03 pm Subject: can we specify keys for a db2 temporary table ? |
| Hi,
can we specify primary key and forign keys for a db2 temporary table? Is referential integrity possible with temporary table? please send link. Thanks Siva |
|
| Topic: How to retrieve rows by checking part of numeric column? |
|
| siva233 Replies: 1 Views: 903 |
Forum: Database Posted: Tue Sep 12, 2006 7:42 am Subject: How to retrieve rows by checking part of numeric column? |
| Hi,
NUMBER ---------- 12340000 ------- 34564568 ------- 12345678 ------- 56780000 ------- I would like to know how to put a condition for checking part of numeric data ... |
|
| Topic: restart step with a duplicate name |
|
| siva233 Replies: 2 Views: 2095 |
Forum: Interview Q & A Posted: Fri Mar 24, 2006 12:01 am Subject: restart step with a duplicate name |
| hi,
This is an interview question. I have a job with two duplicate named steps. The names of step1 and step3 are same. If i want to restart from step3(actual stepname is step1)then what shuold i code ... |
|
| Topic: how to retrieve 5th row only from a table? |
|
| siva233 Replies: 5 Views: 3419 |
Forum: Interview Q & A Posted: Thu Mar 23, 2006 11:46 pm Subject: how to retrieve 5th row only from a table? |
| kolusu,
what is rownumber column? thanks siva |
|
| Topic: how to get all the key information of a table? |
|
| siva233 Replies: 1 Views: 1894 |
Forum: Interview Q & A Posted: Thu Mar 23, 2006 1:25 am Subject: how to get all the key information of a table? |
| hi,
how will i get primarykey, foreignkey, any other key information of a table? thanks siva |
|
| Topic: how to retrieve 5th row only from a table? |
|
| siva233 Replies: 5 Views: 3419 |
Forum: Interview Q & A Posted: Thu Mar 23, 2006 1:09 am Subject: how to retrieve 5th row only from a table? |
| hi,
Both for inserted sequence and result set thanks siva |
|
| Topic: how to retrieve 5th row only from a table? |
|
| siva233 Replies: 5 Views: 3419 |
Forum: Interview Q & A Posted: Wed Mar 22, 2006 12:43 am Subject: how to retrieve 5th row only from a table? |
| I would like to know the sql query(a single query)to retrieve 5th row only from db2 table. | |
| Topic: declaring a cursor |
|
| siva233 Replies: 1 Views: 1814 |
Forum: Interview Q & A Posted: Wed Mar 22, 2006 12:36 am Subject: declaring a cursor |
| This is an interview question.can we declare a cursor in procedure division.If yes, then what is the difference between declaring cursor in ws-section and procedure division? | |
| Topic: 77-level number |
|
| siva233 Replies: 1 Views: 989 |
Forum: Application Programming Posted: Wed Mar 22, 2006 12:27 am Subject: 77-level number |
| An independent data item can be declared with a 01 or 77 level.Is there any particular advantage with 77 level number? | |
All times are GMT - 5 Hours |