mainframegurukul.com

Thanks a lot for your help.
This works for me.

Regards,
Bhaskar

Both the versions are of Fixed Block.

Hi, I have a requirement where in a single GDG, I have two versions which is of different record lengths and I need to sort this GDG bases and need to write to an output file with the minimum record length format. For ex: I have a GDG and it has two versions in it. The first version has a record len...

Thanks a lot for your help.

Regards,
Bhaskar

Hi, I have got a requirement in which I need to do a reference modification for a record in my output file. For ex: Variable1 - PIC X(30). If Condn-1 Move 123 to Variable1(1:5) Move 876 to Variable1(7:3) ... ... ... End-if Can I do this in an easytrieve program? If so, please let me know the syntax....

Hi,
Can we use EVALUATE statement in Easytrieve?
If so, could you please give me the syntax?

Regards,
Bhaskar

Hi,
Could you please let me know whether we can use EVALUATE statement in Easytreive program. If so, pls give the syntax.

If it can be achieved from ICETOOL, I am ready to use it.
I dont have any constraints on it.

Regards,
Bhaskar

Hi, I have a requirement in which I need to sort the records present in an input file and write it to the output file where I dont want to sort the header record which is the first record of the file, but want the header record in the output file. I want to do this in a single step. Could you please...

Hi skolusu,

This really worked fine with my requirment.. Thanks a lot for your help on this.

Hi, In my JCL, the first step is executing DNSTIAUL utility to unload records from a table which is very huge. My WHERE clause is as given below: WHERE AUDIT_UPDT_TS BETWEEN (CHAR(CURRENT DATE - 1)||'00:00:00.000000') AND (CHAR(CURRENT DATE - 1 day)||'23:59:59.999999'). But then my DBA advised me th...

Hi Dick, In continuation with this conversation, my JCL is exexcuting DNSTIAUL utility to fetch records from a table for which you gave a solution to use "WHERE AUDIT_UPDT_TS BETWEEN (figure out the functions necessary to make CURRENT_DATE - 1 day concatenated with 00:00:00.000000) AND (figure out t...

Hi Dick, I really dont know how to check for the amount of time db2 spent manipulating the timestamp datatype to date datatype. If you can tell me how to check that, I shall try it and let you know.. But the original query was taking a time of 18.89 secs for 1500 rows where as this revised query too...

Hi Dick, your query worked and is perfect for my requirement. Thanks a lot for your timely help.

Answers to your queries: how many rows are in the table - there are 15 million records in the table how many rows do you expect to select - I am expecting around 2K rows from the select is the timestamp part of an index - we are also thinking of this as a solution, but would appreciate if I get any ...