Author |
Message |
Topic: COBOL Indentation |
ramu_mohan21
Replies: 7
Views: 4903
|
Forum: Application Programming Posted: Fri Jun 04, 2010 4:12 am Subject: COBOL Indentation |
Hi All,
Do we have any tool which does COBOL Code Indentation. |
Topic: Accessing Child segment with Specified Critieria |
ramu_mohan21
Replies: 2
Views: 2885
|
Forum: IMS Posted: Wed Oct 08, 2008 3:23 am Subject: Accessing Child segment with Specified Critieria |
Hi,
I have another question in the above processing. I don't have a key for parent segment. I need to process all the parent occurrences. But I have a key value i.e "ABC" for one of the c ... |
Topic: Accessing Child segment with Specified Critieria |
ramu_mohan21
Replies: 2
Views: 2885
|
Forum: IMS Posted: Tue Oct 07, 2008 4:38 pm Subject: Accessing Child segment with Specified Critieria |
Hi Board,
I have a small question. In our system there are 2 levels of database is present. Each parent occurrence having multiple child occurence. In one of the child occurence, one of the field ... |
Topic: -805 in REXX DB2 Program |
ramu_mohan21
Replies: 18
Views: 11716
|
Forum: TSO and ISPF Posted: Wed May 23, 2007 11:30 am Subject: -805 in REXX DB2 Program |
/*** REXX ***/
SUBSYS = 'DB2T'
SQLSTMT = ,
"SELECT",
... |
Topic: -805 in REXX DB2 Program |
ramu_mohan21
Replies: 18
Views: 11716
|
Forum: TSO and ISPF Posted: Wed May 23, 2007 9:57 am Subject: -805 in REXX DB2 Program |
HI,
For the above code please anybody can delcare SQLDA declarations. I'm getting confusion in declaring that. I refered manuals and this board also. Still unable to do so. What are the fields are m ... |
Topic: -805 in REXX DB2 Program |
ramu_mohan21
Replies: 18
Views: 11716
|
Forum: TSO and ISPF Posted: Sun May 20, 2007 3:57 am Subject: -805 in REXX DB2 Program |
HI Nic,
My requirement is to get the single column value into a host variable. EMPNO is the primary key on Employee table. Hence I do not want to use cursor. How my requirement can be satisfied? |
Topic: -805 in REXX DB2 Program |
ramu_mohan21
Replies: 18
Views: 11716
|
Forum: TSO and ISPF Posted: Fri May 18, 2007 2:42 pm Subject: -805 in REXX DB2 Program |
HI Board,
SUBSYS = DB2T
SQLSTMT1 = "SELECT SAL INTO :EMPSAL FROM ABC.EMPLOYEE",
" WHERE EMPNO = '123456'" ... |
Topic: REXX Language Processor |
ramu_mohan21
Replies: 3
Views: 2498
|
Forum: TSO and ISPF Posted: Thu May 17, 2007 5:31 am Subject: REXX Language Processor |
Hi,
In which PDS the REXX Language Processor will be available in general mainframes. What is that processor name? |
Topic: SQL Query Help Needed? |
ramu_mohan21
Replies: 4
Views: 2797
|
Forum: Database Posted: Wed Apr 18, 2007 1:02 am Subject: SQL Query Help Needed? |
You are right. I wrote a wrong SQL Query. I didn't keep B.Q2 in GROUP BY Clause. Now it is working fine.
Thank you for your immediate answer. |
Topic: SQL Query Help Needed? |
ramu_mohan21
Replies: 4
Views: 2797
|
Forum: Database Posted: Tue Apr 17, 2007 9:56 am Subject: SQL Query Help Needed? |
HI Kolusu,
I have already tried as you mentioned above. At that time I have below error:
DSNT408I SQLCODE = -122, ERROR: A SELECT STATEMENT WITH NO GROUP BY CLAUSE CONTAINS A COLUMN NAME AND AN ... |
Topic: Usage of DB2 Connect and WinSQL |
ramu_mohan21
Replies: 2
Views: 2945
|
Forum: Database Posted: Tue Apr 17, 2007 8:59 am Subject: Usage of DB2 Connect and WinSQL |
Thanks Kolusu for your clarification. |
Topic: SQL Query Help Needed? |
ramu_mohan21
Replies: 4
Views: 2797
|
Forum: Database Posted: Tue Apr 17, 2007 8:57 am Subject: SQL Query Help Needed? |
HI Board,
I have the data in Table-A(Fields: F1, F2, F3) and Table-B(Fields:Q1,Q2) like below:
Table-A
---------F1 F2 F3
= === =====
A ABC ABCD
A X ... |
Topic: Usage of DB2 Connect and WinSQL |
ramu_mohan21
Replies: 2
Views: 2945
|
Forum: Database Posted: Mon Apr 09, 2007 7:02 am Subject: Usage of DB2 Connect and WinSQL |
HI Board,
Our mainframes System have been divided into 3 parts. 1) Normal Mainframes (Back-end) 2) Front End(Consisting of VB) 3) UNISYS Mainframes. All three systems will interact through messaging ... |
Topic: DB2 Row Updation |
ramu_mohan21
Replies: 1
Views: 2619
|
Forum: Database Posted: Mon Nov 27, 2006 11:59 pm Subject: DB2 Row Updation |
Hi Board,
In our system somebody modified the field in DB2 Production table. Afterwards the night batch JOB will update the table again. Can we find out who has modified the row in DB2 table explic ... |
Topic: INTUNE Manual Required |
ramu_mohan21
Replies: 2
Views: 1941
|
Forum: Database Posted: Mon Mar 20, 2006 7:42 am Subject: INTUNE Manual Required |
Hi,
In our system we are using INTUNE Performance Monitoring tool for Db2. Can anybody help me by providing a manual for this tool. |
|