Variable length (VB) Mainframe input file

Post by **admin** » Wed Jul 11, 2001 8:14 am

Hi there,

were developing a prototype on customer site (Banca Nazionale del Lavoro) and weve a problem during DS cobol program execution; we didnt find the right way to read data from a VB Maniframe file (everything works fine in the case of FB Mainframe file). Could somebody tell us, asap, if DataStage/390 support this kind of Mainframe file (that has 4 byte at the head of each record) and, if yes how ?

Thanks in advance for your cooperation,

Francesco Di Gregorio

---------------------------------------
Francesco Di Gregorio
Datamat - Ingegneria dei Sistemi S.p.A.
Rome - Italy
Tel: +39 06 5027 4155
Fax: +39 06 5051 0333
EMail: fdigrego@datamat.it
---------------------------------------

Post by **admin** » Wed Jul 11, 2001 10:00 am

If the file is available as a text (sequential) file with end-of-line characters, read it with a sequential file stage type in a server job, declaring the file as containing one column of type VarChar then, in a Transformer stage, use the documented metadata to decompose it. If the file does not contain end-of-line characters, pre-process with BASIC (ReadBlk four bytes, then ReadBlk that number of bytes, writing into a file with end-of-line characters) then proceed as above.

-----Original Message-----
From: Francesco Di Gregorio [mailto:fdigrego@datamat.it]
Sent: Wednesday, 11 July 2001 18:15
To: dwsupport.fr@ascentialsoftware.com
Cc: datastage-users@oliver.com
Subject: Variable length (VB) Mainframe input file

Hi there,

were developing a prototype on customer site (Banca Nazionale del Lavoro) and weve a problem during DS cobol program execution; we didnt find the right way to read data from a VB Maniframe file (everything works fine in the case of FB Mainframe file). Could somebody tell us, asap, if DataStage/390 support this kind of Mainframe file (that has 4 byte at the head of each record) and, if yes how ?

Thanks in advance for your cooperation,

Francesco Di Gregorio

---------------------------------------
Francesco Di Gregorio
Datamat - Ingegneria dei Sistemi S.p.A.
Rome - Italy
Tel: +39 06 5027 4155
Fax: +39 06 5051 0333
EMail: fdigrego@datamat.it
---------------------------------------

Post by **admin** » Wed Jul 11, 2001 10:29 am

Hello Ray,

thanks for your prompt reply. The workaround is fine, except for the milions record that Ive to transfer from IBM/390 to DS Server machine and back, but are you confirming me that DS/390 doesnt support input variable Mainframe file (recording mode isVB) ?

Thanks again,

Francesco Di Gregorio

----- Original Message -----
From: Ray Wurlod
To:
Sent: Wednesday, July 11, 2001 12:00 PM
Subject: RE: Variable length (VB) Mainframe input file

> If the file is available as a text (sequential) file with end-of-line
> characters, read it with a sequential file stage type in a server job,
> declaring the file as containing one column of type VarChar then, in a
> Transformer stage, use the documented metadata to decompose it. If the
> file does not contain end-of-line characters, pre-process with
BASIC
> (ReadBlk four bytes, then ReadBlk that number of bytes, writing into a
file
> with end-of-line characters) then proceed as above.
>
> -----Original Message-----
> From: Francesco Di Gregorio [mailto:fdigrego@datamat.it]
> Sent: Wednesday, 11 July 2001 18:15
> To: dwsupport.fr@ascentialsoftware.com
> Cc: datastage-users@oliver.com
> Subject: Variable length (VB) Mainframe input file
>
>
> Hi there,
>
> were developing a prototype on customer site (Banca Nazionale del
> Lavoro) and weve a problem during DS cobol program execution; we
> didnt find the right way to read data from a VB Maniframe file
> (everything works fine in the case of FB Mainframe file). Could
> somebody tell us, asap, if DataStage/390 support this kind of
> Mainframe file (that has 4 byte at the head of each record) and, if
> yes how ?
>
> Thanks in advance for your cooperation,
>
> Francesco Di Gregorio
>
> ---------------------------------------
> Francesco Di Gregorio
> Datamat - Ingegneria dei Sistemi S.p.A.
> Rome - Italy
> Tel: +39 06 5027 4155
> Fax: +39 06 5051 0333
> EMail: fdigrego@datamat.it
> ---------------------------------------
>
>

Post by **admin** » Wed Jul 11, 2001 11:27 am

Francesco,

I have no experience at all with DS390. Others will have to answer this. Perhaps the complex flat file stage has a capability you could use. I only suggested a workaround based on my (server only) experience.

Regards,
Ray