 |
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 18 matches |
| Author | Message |
|---|---|
 Topic: SAS-Packed decimal format |
|
| vijayakumar Replies: 0 Views: 5975 |
 Forum: Application Programming Posted: Tue May 15, 2012 5:10 am Subject: SAS-Packed decimal format |
| I have a field in cobol file with field S9(18 ) comp-3 and writing in SAS dataset. In SAS the field is defined as CUST_ID PD10.
In order to verify the data in the sas dataset, the sas field is writ ... |
|
| Topic: Removing leading zeros for varchar field using sort |
|
| vijayakumar Replies: 5 Views: 9773 |
Forum: Utilities Posted: Fri Apr 27, 2012 12:47 pm Subject: Removing leading zeros for varchar field using sort |
| Thanks kolusu.. | |
| Topic: Removing leading zeros for varchar field using sort |
|
| vijayakumar Replies: 5 Views: 9773 |
Forum: Utilities Posted: Tue Apr 24, 2012 10:40 pm Subject: Removing leading zeros for varchar field using sort |
| Hi,
I have a requirement to remove the leading zeros for varchar(40) field using sort. We can use JFY=(SHIFT=LEFT)) to remove the leading zeroes but whether it is possible to calculate the length als ... |
|
| Topic: Matching Logic using ICETOOL |
|
| vijayakumar Replies: 8 Views: 6268 |
Forum: Utilities Posted: Sun Aug 09, 2009 2:12 am Subject: Matching Logic using ICETOOL |
| Hi Kolusu,
Thanks very much for your help. I will update the staus once i complete the code testing. Thanks Vijayakumar |
|
| Topic: Matching Logic using ICETOOL |
|
| vijayakumar Replies: 8 Views: 6268 |
Forum: Utilities Posted: Fri Aug 07, 2009 4:11 am Subject: Matching Logic using ICETOOL |
| Hi Kolusu,
Please find the details below, 1) Format of the input files Input file 1: LRECL:30 , RECFM:FB 01 INP1-REC 05 POL-NO PIC X(8) 05 NAME-ADD PIC X(22) Input file 2: L ... |
|
| Topic: Matching Logic using ICETOOL |
|
| vijayakumar Replies: 8 Views: 6268 |
Forum: Utilities Posted: Thu Aug 06, 2009 1:44 pm Subject: Matching Logic using ICETOOL |
| Hi,
I have a requirement to match two input files and generate the output files in the below format. I tried using ICETOOL SPLICE but i am not getting the expected output. Could you please help me ... |
|
| Topic: SQL output using Groupby statement |
|
| vijayakumar Replies: 2 Views: 2286 |
Forum: Database Posted: Thu Jul 23, 2009 1:55 am Subject: SQL output using Groupby statement |
| Kolusu,
I am getting the expected result with your query. Thanks very much for you help. |
|
| Topic: SQL output using Groupby statement |
|
| vijayakumar Replies: 2 Views: 2286 |
Forum: Database Posted: Wed Jul 22, 2009 12:13 pm Subject: SQL output using Groupby statement |
| Hi,
I have a problem regarding SQL query, I am not getting the expected output, if the where condition is not satisfied the count should be displayed as zero. Could you please help me. TABLE VALUE ... |
|
| Topic: Defining and accessing arrays in easytrive |
|
| vijayakumar Replies: 4 Views: 2739 |
Forum: Application Programming Posted: Mon Aug 04, 2008 4:28 am Subject: Defining and accessing arrays in easytrive |
| Hi
I could not find more information about the occurs in the Quick manuals.. Could you please help me.. Vijay |
|
| Topic: Defining and accessing arrays in easytrive |
|
| vijayakumar Replies: 4 Views: 2739 |
Forum: Application Programming Posted: Sun Aug 03, 2008 3:52 am Subject: Defining and accessing arrays in easytrive |
| Hi,
I have the following record structure for input file in Easytreive IN-FEE-CD -Fee code values are SF, CF, RF, PF,AF, etc., I need to search the fee code values for SF, RF and PF and move ... |
|
| Topic: Defining and accessing arrays in easytrive |
|
| vijayakumar Replies: 0 Views: 1231 |
Forum: Application Programming Posted: Sun Aug 03, 2008 3:51 am Subject: Defining and accessing arrays in easytrive |
| Hi,
I have the following record structure for input file in Easytreive IN-FEE-CD -Fee code values are SF, CF, RF, PF,AF, etc., I need to search the fee code values for SF, RF and PF and move ... |
|
| Topic: Extracting last record |
|
| vijayakumar Replies: 5 Views: 2984 |
Forum: Utilities Posted: Thu Nov 08, 2007 9:36 am Subject: Extracting last record |
| Hi Frank,
Thanks for your help!!!!!!! Logic worked fine.... Cheers Vijay |
|
| Topic: Extracting last record |
|
| vijayakumar Replies: 5 Views: 2984 |
Forum: Utilities Posted: Wed Nov 07, 2007 11:31 am Subject: Extracting last record |
| Hi,
In the file there will be many policy numbers. For each polisy number all the latest date records should be written to output file. RECFM=FB, LRECL=25 Polisy number X(9) Tran Date X( ... |
|
| Topic: Extracting last record |
|
| vijayakumar Replies: 5 Views: 2984 |
Forum: Utilities Posted: Wed Nov 07, 2007 7:08 am Subject: Extracting last record |
| Hi,
I need to extract the last four records from the input file based on pol number, latest date(yyyymmdd). Is there any icetool or sort command to do this. Could you please help me on this proble ... |
|
| Topic: Query Problem in accessing Database |
|
| vijayakumar Replies: 1 Views: 1505 |
Forum: Database Posted: Wed Oct 25, 2006 8:03 am Subject: Query Problem in accessing Database |
| Hi
I am getting efficiency problem while running this db2 query in cobol program it takes more time to run. This query will fetch the columns based on the matching keys present in the table and f ... |
|
All times are GMT - 5 Hours |