DSXchange

I created a parameter sets in Datastage V 8.0.1 and it contained three parameters Database server name,database id and password. I want to use those parameters in 10 jobs which are teradata multiload stage. In the Teradata Multiloadstage when i pass the parameters for server, Database id and passwor...

We used option 2 of grep the records by filter property and load it to a table by running the job 48 times.

We used option 2 of grep the records by filter property and load it to a table by running the job 48 times.

Thank you everyone for input.

I would prefer the third option,How we can flatten the structure to ALL column format?

We have 48 different types of records in the same file. first two fields of each record identify which table to load the data and next two fields are the key fields.So from third field to last field of the record goes to table. Maximum possible fields out of different 48 recrord types are 138.so we ...

I have a flat file with varaible length fields and records with a field delimiter of ^ symbol, I need to identifyand load them to different tables. based on the first two fields i need to identify which table the record goes and then use third and fourth fields as key fields for record insert/update...

Not in one shot all 3000 tapes, but for one time we want to move.I appreciate your thoughts and i will go with reading the tapes and move it to disk and then handle with CFF stage.

thank you everyone.

We want to move the data as one time effort from mainframe tapes to unix flat files.

we have around 3000 mainframe tapes containing comp fields and occurs depending on(variable length records).

I want to know is there a way to do that using Datastage?

I am using Datastage 8.0.1 , Is there a way to connect and read a data on Mnainframe tapes and move to Unix box?

Any help is greatly appreciated.

Thanks.

Ray,

Can you tell where we have the resource estimator tools with in Information Server/DataStage.

Thanks.

Hi,

Is there any reporting feature in IBM Info Server Version 8.0.1 that can give a CPU utilization and Disk space availability at a given point of time.
If not what is the best practice to get that information on a regular basis for reporting purpose.

Thanks.

All I need is a path on unxi box generally where i can find the license.xml file.

Where can i find my License.xml file, my datastage is installed on Unix box. Any help is appreciated.

I updated my SQL Server Connection info in odbc.ini file and uvodbc.config file and try to test the connectivity using brandedodbc/example and it is throwing the below error.Any ideas greatly appreciated. SQLSTATE = 01000 NATIVE ERROR = 5701 MSG = [DataDirect][ODBC SQL Server Driver][SQL Server]Chan...