DSXchange

Please let me know whether DataStage can write into a Mainframe GDG or not. If yes, then how to do that.

did you try the FTP stage

I haven't tried, just wondering how we'll do that with FTP stage. Say, I have a family of GDG's called 'XYZ.ABC'. How do I use this in FTP stage.

simplest will be generating a sequential file and then FTP to the GDG

Thanks for your reply.

Could you plz tell me where shd I mention the GDG name in FTP stage, I think it is not in URI.

simplest will be generating a sequential file and then FTP to the GDG

for this use OS command line FTP, may be in a after job routine execute command..

example :
ftp -inv << EOF
open $vHost
user $vUsr $vPwd
quote site RECFM=VB LRECL=256
ascii
put $UnixFileName $vMVS
close
bye
EOF

Thanks again.

Please explain the following lines :

1. quote site RECFM=VB LRECL=256

Is it setting some parameter before FTP?

2. put $UnixFileName $vMVS

Is $vMVS the GDG name ?

1. After FTP , for the GDG parameter

2. Yes, If you was new version of GDG the <GDG NAME>(+1)

FTP stage can very well handle it. In the remote file name provide the fully qualified name of the dataset, eg: 'xyz.abcd.aaaaaa.gdgname(+1)'. This way every time it will create a new generation on the mainframe.

I am very new to Mainframe & haven't come across this term GDG before.

Could you plz tell me :

1. What do these parameters RECFM=VB and LRECL=256 suggest.
2. What is meant by <GDG Name>(+1)

RECFM means [u]REC[/u]ord [u]F[/u]or[u]M[/u]at. In this case it's [u]V[/u]ariable [u]B[/u]lock.
LRECL means record lenght. In this case it's = 256 bites
GDG means Generation Data Group - a collection of historical related data sets that are arranged in chronological order.
The name HLQ.ABCS.EFG(0) means current data set, the most recent existing file.
The numbers may go in both directions.
HLQ.ABCD.EFG(-1) means previous data set.
HLQ.ABCD.EFG(+1) means new data set.

Sorry, I was sloppy.
RECFM means RECord ForMat. In your case it's Variable Block.