DSXchange

Craig, The data looks like this in the csv file "Jul 31, 2009","956,611","15,907,101","2,577,527","794,461","21,736","696,030","85,138","93,019","$5,757,194","41,808","275,639" I h...

Friends, I am trying to design a job which populates a staging table with the data present in a Sequential file. The design itself is very simple File ==> Transformer ==> ODBC The file we receive is comma delimited. The problem is that the data in the file contains commas (3,890,454) After defining ...

Thanks for the information.
I have modified the job to OCONV(ICONV(dslink3.indate,"DMDY"),"D-YMD[4,2,2]") and it worked

Thanks
Yamini

Friends, I'm trying to create a new job which parses a Sequential file and populates a staging table. The problem is with one of the date columns present in the file. The format of the data is "Jul 31 2009" (MM DD YYYY) whereas the DataStage function ICONV expects it in "DD MM YYYY&qu...

Ray,

We use only the basic funtionality of DS. Do you think waiting for version 9 is a good idea?

Thanks
Sunil

Friends,

Currently we have DataStage 7.5 installed in all our environments.
Is it worth it to upgrade to 8.0? Please guide me to the posting, if any, which discusses the topic

Thanks
Yamini

Hello friends, Sorry for posting the question in this section as I couldn't figure out an appropriate section. I am trying to design a table which is intended to hold data related to vendors. Every vendor can receive one or more orders. The table should hold vendors along with orders received For ex...

The application is installed on Linux. On other note, I had to restart the DS engine to clear all the dead processes

The application is installed on Linux OS

The application is installed on Linux OS

The first command (ipcs -mp |grep ade) didn't list any thing and the second command (ps -ef |grep -v grep |grep dsapi) listed only one process
dstage 32410 32409 0 17:14 ? 00:00:01 dsapi_slave 8 7 0

Am I doing anything wrong?

Yamini

The first command (ipcs -mp |grep ade) didn't list any thing and the second command (ps -ef |grep -v grep |grep dsapi) listed only one process
dstage 32410 32409 0 17:14 ? 00:00:01 dsapi_slave 8 7 0

Am I doing anything wrong?

Yamini

Craig, I have searched the forum and found some useful information. The following is the output of the command uv -admin -info Details for DataStage Engine release 7.5.1.2 instance "ade" =============================================================================== Install history : Insta...

Craig,

I mistakenly mentioned that we have 8x version but in fact the version on our server is 7.5.
Can you please list the steps to kill the zombie session on 7.5

Thanks
Yamini

Craig,

How can I remove the dead/zombie processes from the server?

Thanks
Yamini