 |
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 12 matches |
| Author | Message |
|---|---|
 Topic: Reg: Transact SQL syntax |
|
| valeti_sashi Replies: 0 Views: 1205 |
 Forum: Database Posted: Mon Dec 11, 2006 4:08 am Subject: Reg: Transact SQL syntax |
| Hi,
I am converting a couple of sybase sps to DB2. can any one tell the Transact sql syntax for Left outer join or please provide me with some tutorials. Thanks in advance, |
|
| Topic: Regarding multiple left outer joins |
|
| valeti_sashi Replies: 0 Views: 1353 |
Forum: Database Posted: Wed Nov 08, 2006 3:27 am Subject: Regarding multiple left outer joins |
| Hi,
i am converting Sybase queries to DB2 quries. i have problem in converting a query which involves mutiple left outer joinms: select ac.acct_id, ac.n_pbt_cnty, ac.c ... |
|
| Topic: DB2 Query |
|
| valeti_sashi Replies: 1 Views: 1558 |
Forum: Database Posted: Tue Oct 03, 2006 8:34 am Subject: DB2 Query |
| Hi,
I am geting error in the following query. can any one tell if the syntax is correct. Query: SELECT SUBSTR(TS.PRNT_GRP_MNEM,1,1) 00000001 ... |
|
| Topic: Building SQL Stored procedure |
|
| valeti_sashi Replies: 5 Views: 2483 |
Forum: Database Posted: Thu Sep 14, 2006 12:02 am Subject: Building SQL Stored procedure |
| Shekar,
i already have this PDF and gone thru it. But this doesn't answer my question. how to build/compile SQL Stored Procedure. is there any command in SQL itself like Compile in oracle or do w ... |
|
| Topic: Building SQL Stored procedure |
|
| valeti_sashi Replies: 5 Views: 2483 |
Forum: Database Posted: Wed Sep 13, 2006 11:43 pm Subject: Building SQL Stored procedure |
| Shekar,
I know how to create and execute Stored procedure. In between these two we to compile the procedure. I want, how to do that. |
|
| Topic: Building SQL Stored procedure |
|
| valeti_sashi Replies: 5 Views: 2483 |
Forum: Database Posted: Wed Sep 13, 2006 11:17 pm Subject: Building SQL Stored procedure |
| Hi,
i had created a pure SQL stored procedure in DB2. Now the question is how to build/compile it. is there any command in SQL itself like Compile in oracle or do we have to use a JCL compiler for ... |
|
| Topic: SQL stored procedures |
|
| valeti_sashi Replies: 5 Views: 2775 |
Forum: Database Posted: Wed Aug 30, 2006 3:17 am Subject: SQL stored procedures |
| Christian,
sorry my first is specfied wrongly, actual doubt is do we need to create a Plan or only binding is sufficient thanks for the answers. regards, sashi. |
|
| Topic: SQL stored procedures |
|
| valeti_sashi Replies: 5 Views: 2775 |
Forum: Database Posted: Wed Aug 30, 2006 1:36 am Subject: SQL stored procedures |
| Kolsu,
i know how to code these procedures, but my question is to use? i tried compiling of a simple COBOL procedure. My doubts are 1. do we have to create a Package for the procedure or only bin ... |
|
| Topic: SQL stored procedures |
|
| valeti_sashi Replies: 5 Views: 2775 |
Forum: Database Posted: Tue Aug 29, 2006 12:36 am Subject: SQL stored procedures |
| Hi All,
i have created a COBOL stored ptrocedure in SPUFI. if i have to use the procedure in my program, what i have to do (ie shouild i complie the procedure, how to compile ?). please metion the ... |
|
| Topic: System Date and Time |
|
| valeti_sashi Replies: 7 Views: 2881 |
Forum: Job Control Language(JCL) Posted: Wed Dec 21, 2005 5:24 am Subject: System Date and Time |
| hi,
is there any way we can get system date and time from the JCL. i mean without usig any cobol programs like that, i want direct JCL command thanks in advance, |
|
| Topic: Help sending an Excel file as email attachment thru Mainfram |
|
| valeti_sashi Replies: 5 Views: 9825 |
Forum: Job Control Language(JCL) Posted: Thu Jun 02, 2005 4:06 am Subject: Help sending an Excel file as email attachment thru Mainfram |
| We are facing a problem in sending excel files through XMITIP.
I tried sending a PS file as excel created by focus code, using XMITIP step. But the JCL gave an error message saying ' |
|
| Topic: extract 50 records |
|
| valeti_sashi Replies: 3 Views: 2180 |
Forum: Job Control Language(JCL) Posted: Wed May 18, 2005 11:05 am Subject: extract 50 records |
| HI,
You CAN USE IDCAMS ALSO FOR THIS PURPOSE OBSERVE THE FOLLOWING PIECE OF CODE, I HAD TESTED IT: " 000006 //STEP1 EXEC PGM=IDCAMS 000007 //SYSPRINT ... |
|
All times are GMT - 5 Hours |