DSXchange

Hi All I have a scenario here Input : Col 1, Col 2, Col 3 ============= 1, abc, 123 1, abc, 123 1, abc, 456 2, def, 111 2, def, 112 Output : Col 1, Col 2, Col 3 ============= 1, abc, 1 1, abc, 2 1, abc, 3 2, def, 1 2, def, 2 Can please suggest how can I do this using stage variables ? my source and ...

Thanks Ray !!!

I'm able achieve it very easily.

viewtopic.php?t=97681&start=0&sid=5e14c ... f8d3276cae

This post had helped me.

Hi All I have a scenario as below input - oracle table ============ col1 col2 ------------- 1 Sports 3 News 1 News 2 Weather 1 Weather 3 Sports My output should have =============== col1 col2 ------------------------- 1 Sports News Weather 2 Weather 3 Sports News Currently I'm doing it by a SQL quer...

Hi Andrw

Im not a premium member of forum.

So if possible can you please paste the content outside ?

Thanks
Suresh

Hi All

Good Evening!!

Can you help me out with some code that I can email an attachment through datastage.

Is there any other simpler way to do it in v7.0 ?

Thanks much in advance.
Suresh

Hi I have an other job where i'm using ftp plugin..and the waring message is FTP_Plug_in_1: Connection to the remote host's FTP server failed, host name not found My administrator says he had set up sftp connections and opened firewalls. What exactly could be happening ? why is datastage not finding...

Hi Ray

Still its the same warning


Ftp..FTP_Plug_in_1: 550 CWD failed. "/EDW_Download_Main": directory not found.

Hi Chulett

I think pathname is the directory to where the files are written.

I have tried D:\EDW_Download_Main\ and D:/EDW_Download_Main/

where do you think i'm wrong

Please suggest

Thanks
Suresh

Hi

I'm using ftp plugin stage to ftp a dummy file a windows server.

But the warning is Ftp..FTP_Plug_in_1: 550 CWD failed. "/D:/EDW_Download_Main": directory not found.

but i'm specifying D:\EDW_Download_Main\

Can you suggest whats happening and how to resolve.

Thanks in advance.

Hi Chulett

I can see my session completed from Oracle Enterprise manager.

Hi I'm trying to select data using OCI 8 stage ( Source ) with the query type option as Load SQl from a file at run time. I'm able to see the oracle session has completed ...but the control is not back to datastage. The job is still running with no data selected. Im using datastage 7.5.1A Suggestion...

Hi Raja and Ray

Thanks very much for your answers.

I'll try and implement the logic.

Hi All Thanks for suggestions. I have tried - 1. Clear status file - im not able to compile 2. Clean up resources and logout - not showing PID for the job. So , i have renamed my jobs and imported into production. But those jobs are " still working hard " Please suggest me a solution ...ju...

Hi Chulett Thanks for your reply. ps -ef |grep phantom did not show my job name. There are 2 sequences and a job running since 5 days. I'm not able to compile those ....saying cannot give exclusive access.. Please suggest.. These 3 jobs are in production now.. i need to stop those and reimport from ...

Hi Chulett Thanks for your reply. ps -ef |grep phantom did not show my job name. There are 2 sequences and a job running since 5 days. I'm not able to compile those ....saying cannot give exclusive access.. Please suggest.. These 3 jobs are in production now.. i need to stop those and reimport from ...