Search found 23 matches

by nrajini
Thu Jun 20, 2013 11:54 am
Forum: TSO, CLIST & REXX
Topic: Regarding FILE and SQL
Replies: 2
Views: 4101

Regarding FILE and SQL

Hi All, I have got a requirement that needs to be implemented thru Rexx File length - 400 We need to extract 2 fields from the file Field1 = 3 bytes (Starting pos = 35 ) Field2 = 9 Bytes ( Starting pos = 324) We need to retrive these 2 fields and use these fields in the where clause of a dyanamic qu...
by nrajini
Thu Jun 20, 2013 8:58 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Regarding File extracting 2 fields and using in SQL
Replies: 3
Views: 5027

Regarding File extracting 2 fields and using in SQL

Hi All, I have got a requirement that needs to be implemented thru JCL File length - 400 We need to extract 2 fields from the file Field1 = 3 bytes (Starting pos = 35 ) Field2 = 9 Bytes ( Starting pos = 324) We need to retrive these 2 fields and use these fields in the where clause of a dyanamic que...
by nrajini
Fri Jul 16, 2010 1:45 pm
Forum: COBOL
Topic: Doubt in cobol declaration
Replies: 3
Views: 5662

Thanks for the reply..

Amount field in input file is 593.92 in Input file

One more doubt , as that amount field in input will occupy 6 bytes and if we decalare it as s9(3)v99 it will have only 5 bytes.. so there will be a mismatch between the input file and the record layout how to over come this.
by nrajini
Fri Jul 16, 2010 10:39 am
Forum: COBOL
Topic: Doubt in cobol declaration
Replies: 3
Views: 5662

Doubt in cobol declaration

Hi I have got an amt field in input file , say 958.92

How is that I have declare it in cobol prog to recieve it.

When I display amt it should be displayed as 958.92
by nrajini
Mon Mar 08, 2010 3:52 pm
Forum: DB2 INTERVIEW QUESTIONS
Topic: Regarding Cursor
Replies: 4
Views: 9217

Regarding Cursor

In COBOL-DB2 program without using cursor can we go for any other logic which is more efficient ?
by nrajini
Sat Mar 06, 2010 6:11 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: db2 architecture and concepts
Replies: 1
Views: 3497

db2 architecture and concepts

Hi, Pls provide some ebooks or links for db2 architecture.
by nrajini
Thu Nov 19, 2009 1:39 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: SPUFI
Replies: 5
Views: 9217

Hi, The problem could be MAX SELECT LINES ===> 200 ..in spufi default screen. So it displays only 200 rows even if u specify fetch first 300 rows. Solution : ======= In Spufi screen give CHANGE DEFAULTS = YES ; u will got to spufi default screen There u will find max select lines ( 3rd row ) MAX SEL...
by nrajini
Tue Jul 14, 2009 1:11 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Builtin Funtion in DB2
Replies: 1
Views: 3567

Builtin Funtion in DB2

Hi,

Is there any builtin funtion to display the month and year in the below format..


JULY 09
by nrajini
Mon Jun 22, 2009 4:45 pm
Forum: CICS
Topic: Regarding TSQ
Replies: 3
Views: 11413

Regarding TSQ

Kindly clarify -

Pls let me know how to implement scrolling logic using Tsq ?
by nrajini
Wed May 27, 2009 3:59 pm
Forum: COBOL
Topic: Regarding DBCS datatypes
Replies: 1
Views: 3697

Regarding DBCS datatypes

How is DBCS datatypes declared in cobol ?
by nrajini
Wed May 27, 2009 3:58 pm
Forum: COBOL
Topic: Dfference between CALL BY CONTENT and CALL BY VALUE
Replies: 1
Views: 7478

Dfference between CALL BY CONTENT and CALL BY VALUE

What is the difference between CALL BY CONTENT and CALL BY VALUE ?
kindly explain
by nrajini
Tue May 05, 2009 2:30 pm
Forum: COBOL
Topic: Regarding Comp-1 and Comp-2
Replies: 3
Views: 5813

Regarding Comp-1 and Comp-2

How will PIC '9(4)' be represented in Comp-1 & Comp-2 internally ?
by nrajini
Tue Dec 02, 2008 5:26 pm
Forum: COBOL
Topic: Comparing 2 files based on Acct number without using tables
Replies: 7
Views: 18368

Thanks
by nrajini
Wed Nov 26, 2008 4:46 pm
Forum: COBOL
Topic: Comparing 2 files based on Acct number without using tables
Replies: 7
Views: 18368

Hi All,

Using ICETOOL utility we can compare the files quickly . But I need to do it in Cobol. Since I am new to Cobol I didnt know how to do . Pls help me.
by nrajini
Thu Nov 06, 2008 1:17 pm
Forum: JCL
Topic: SYSUDUMP and SYSABEND
Replies: 4
Views: 12072

SYSABEND DD statement Produces a dump of user and system areas; this dump contains all the areas dumped in a SYSUDUMP, plus: 1) The local system queue area (LSQA), including subpools 229, 230, and 249 2_ The input/output system (IOS) control blocks for the failing task. The dump is formatted, so tha...