DSXchange

Did you try restoring the file using the any backup dsx?

The mere presence of the DB2 Stage in the EE edition does't gurantee that you can pull everying out of Mainframe. You will have to understand that they are VSAM, QSAM files which have to be extracted out of the mainframe using JCL and into a CFF. So if the MVS Editon were to provided functionality t...

Yes...It's all about using the DSN.

The DB2 Database installed on the Mainframe is generally queried via a terminal emulator and the DSN is how you do. So you could go ahead and use the same DSN setup for querying in your DS EE job.

HTH.

Aditya.

It's not DataStage jobs alone which need to be scheduled they are a ton of other process (example BI, Messaging Services etc.,) which also need to sync up and third party scheduling tools don't understand what a Job Sequence is they understand only UNIX Scripts!!!! :D

-- Aditya.

As the error suggest look for the presence of the ds.rc file in the path specified by the error message.

Also look for the file presence using the windows search utility. If the file is present in another location copy it back to the specified location and now restart your server

HTH
Aditya.

If you are want to concatanate the field value to the key it can be done with the concatanate operator (:)

in which case your expression evalutes to

DSLinkXX.SO_ID:"*":DSLinkXX.LINE

HTH

Aditya.

Try trimming the year field as YY instead of YYYY.

Play around with the options of ICONV.

HTH
Aditya.

Have another script that caputures the log for all individual Datastage jobs invovled in the sequence. That way you have both the sequencer as well as the individual job logs.

HTH

Aditya.

For scenarios 1) & 2) you could use a routine or transform

Just append the time as 00:00:00 at the end of the Date value.

HTH

Aditya.

Yes you can. The file is nothing but a CSV file in your case a 'COLON SEPERATED FILE'. Just specify the filepath in the Sequential File Stage and select the seperator to be a ';'. Also set the quote character to '000'

HTH

Aditya.

All, I have a sequential file named SPro_KIND.sqf in the /datastage/dev/..../Product/ directory and I'm trying to create a hash file of the same using the mkdbfile. The command for creating the same has been /opt/dsadm/Ascential/DataStage/DSEngine/bin/mkdbfile SPro_KIND 2 1 16 However I get the erro...

If you are unsure about the size of the datasets then Join stage would be best suited for you application.

Sainath, I had worked on the BW Pack. And the system over there was that the ABAP prorgrammers built process chains and infospokes ( a hub and spoke architecture ) and data flowed thru these spokes. The data was being made available by them thru processes known to them ( ie. they could have done som...

Are those tables part of SAP BW

No. This functionality has to be definetly be implemented by the ABAP Programmers who will have to then give you the process chains and infospokes for you to extract the data

-- Aditya.