DSXchange

Hi, I am trying to use DataStage to convert data to XML format. I have looked at the XML pack Designer Guide but the 3 XML input stage, XML output stage and XML transform stage in the guide is different from the datastage 7.1.5a, the properties are also different. The online help does not have much ...

Hi, Our situation is Mainframe will ftp the DDS files generated by CDC to the DSEE in AIX. Our challenge is we have to ensure the DDS files from mainframe transfer to AIX are not coroupted and fully ftped before DSEE proceed. How can I go about it? How do I tell DSEE not to proceed if FTP files are ...

Hi,

What if the Excel file has multiple sheet? how can I extract tables in the subsequence sheet?

Please advise. Thanks.

Hi,

Anyone of you has an idea to import table in an Excel worksheet to a DB2 table?

Hi,

Anyone has an idea to load all the Ms. Word files in a folder to a DB2 tables as one file one record and the column datatype is text?

I have a dataStage installed in an AIX machine. The source DB2 database is in AS400. After installing the DB2 connect in the AIX, we are able to connect and see the tables in the AS400 using DB2 command line. I use DataStage Manager and DB2 plug-in, I can see the database and the list of tables in t...

Ogmios,

Please tell me what do you mean by correctly setup dsadm.
My setup might be wrong.

I have created a user call dsadm and then I installed datastage using root. After reboot, datastage is automatically started. Then I stop datastage using root. I login as dsadm and do a $dshome/bin/uv -admin -start it promprs me for password, I then keyin dsadm password, yet it prompts me for passwo...

What do you mean by correctly setup dsadm? I have done this 1.) create the dstg directory 2.) create user dsadm but not manage to assign dstg as home directory 3.) use root to install datastage 4.) manage to assign dstg directory as dsamd's home directory Now dsadm cannot stop and start. It looks li...

That means I have done the right thing because I am using root to install datastage.
Please tell me in detail how can I make dsadm to be able to stop and start DS. I am using Sun Solaris and I am not very good at Sun Solaris, please guide me step by step.

Thanks

May I know which website has DataStage installation guide?

Hi,

I wonder dsadm can stop and start DataStage v6.0 on Sun Solaris 8 platform

Is dsadm the supper user?

I am using Quality Manager

Hi,
I have 2 exception table. In the Exception Report windows, Exception Table List, I can only see one Exception Table.

Please tell me how can I see all the Exception Table. I need to create the Exception Report.

Thanks.

Hi, I have a salutation table that contain all the valid salutations e.g. Dr. Dato Dr. Tan Sri Dato Dr. Tan Sri YB YB DATIN Yang Berhormat I have another table that contain people information including the name and name with salutation in a column called WholeName. The Name column contains e.g. Pete...