mainframegurukul.com

Hi,
While compiling the DB2 module there comes an option 'precompile variables = (Y/N)'. I want to know when and why we use it.

Where is the user defined function(db2 mainframe) is stored? and where can i see the user defined function created by others?

Can I get an equivalent of sort card for ICETOOL utility? I don't have any experience on ICETOOL.

After searching google I received following two ways to pass the value.

1. DFSPARM
2. SYMNAMES

I think (whatever the examples I saw) we can only pass some hard-coded value. Instead of these hard-coded value I want to pass the variable which hold the date.

In my jcl there is a variable GL0066 which I'm using to hold the required date and want it pass to the build parameter in outrec of the sort sysin.

JPn is supported only in DFSORT/ICETOOL but not in SYNCSORT.

Hi,
The S9(04) COMP PIC clause is used to store the length of the PARM field from JCL or the length of the variable length column of the table.

When length of any field cannot be negative then why we mention sign in the COMP pic clause??????

For NULL indicator keeping sign I can see much use.

Hi All, In my application, for every new FTP card we write a module so that the we can use the current working day or previous working day as a part of the Non-Mainframe file name. Rest of the parameter is hard coded. ex: ABCDEFGH.US.COM USERNAME PASSWORD CD FOLDER1 CD FODLER2 PUT HXXXXXX.X.XXXXXX.X...