View previous topic :: View next topic |
Author |
Message |
chandrasekhar.a Beginner
Joined: 05 Apr 2006 Posts: 7 Topics: 3
|
Posted: Tue May 22, 2007 6:08 pm Post subject: Unload job executing ALPMAIN |
|
|
Hi,
I have this job which executes this program ALPMAIN(LOGSCAN EXEC PGM=ALPMAIN). Here is the SYSIN card for this step. I dont have access to any of the files or even the jcl. I just have this file ABC.DEF.GHI and I was told it is unload of a table. So I am guessing this program is unloading data from this table into this dataset. But I am not sure.
LOGSCAN
LOAD
DATASET ABC.DEF.GHI NEW
UNIT(TAPE) RETPD(45)
CONTROL xxx.xxx.xxx.xxx.xxx OLD
FORMAT UNLOAD PLUS
SEPARATE DATASETS NO
UPDATES AFTER
DB2CATALOG NO
FROM DATE(xxxx-xx-xx) TIME(00.00.00.000000)
TO CURRENT
WHERE TABLE NAME IN (
xxxxxx.xxxxxx)
ONGOING HANDLE 194
After this step there is one more exec (PGM=AMUUMAIN) which takes the dataset ABC.DEF.GHI as its SYSREC card. I am thinking this one uploads the data from this dataset into another table. I am not sure of this either.
Here is my requirement. I need to read this file in one of my programs and I am not sure of the format for one of those fields. The DB2 field type for this field is of type DOUBLE FLOAT and is present in the file from position 1 to 8.
I had never run across these executables. But i know they belong to BMC utilities. Can someone one throw some light on these and provide any links to manuals related to these? |
|
Back to top |
|
 |
kolusu Site Admin

Joined: 26 Nov 2002 Posts: 12382 Topics: 75 Location: San Jose
|
|
Back to top |
|
 |
chandrasekhar.a Beginner
Joined: 05 Apr 2006 Posts: 7 Topics: 3
|
Posted: Tue May 22, 2007 8:31 pm Post subject: |
|
|
Thanks!! |
|
Back to top |
|
 |
|
|