DSXchange

Thankyou everybody let me try that.

The only thing is complex SQL. Either I use DS or TOAD I have to write custom SQL. So I am asking is DS necessary or TOAD should be fine for the same ?

Or else make a table using TOAD and then use DS to load it ???

Ok so Data stage does not come in the picture then. So the steps:

Create Table using TOAD
write required SQL
populate the table with required columns

Right ??

Join is not a problem other parameters are to be checked. Its like 3 to 4 tables. And I need a staging table to store this. So my question is , is DS required for this purpose or i can do it in TOAD ? To build staging table...

Thanks

Hi All,

I have to create staging table. That has to be done by entering custom SQL which is a bit complex as it has many joins. Can any body suggest how shall I proceed ?

Database is Oracle.

Can I do it by TOAD or DS ?

Thanks.

Try to see the access rights of the file to which you are writing the output.

change it to

chmod 777 filename

It will be fine.

Thanks

But what if I use DSJobStartDate in seq file name like -

test_#DSJobStartDate#.txt

But i have a problem it will append like

test_2006-08-01.txt

and I want test_08012006.txt

And I didnt get your sequencer concept ?

I have ran the job and the file test.txt is created. Now I want to append current date in format :

test_MMDDYYYY.txt

Is there any way in Datastage or will have to write a shell script ? And if a shell script how shall i proceed ?

Thanks

So kriss007 you mean just to re-run the job. It should be fine now ? No other issue except the broken link rite ?

I am getting this error :

ORA-03113: end-of-file on communication channel

I have not seen this error before. Can any one share their experience ?

Thanks.

Thanks kduke. Let me try and will let you know if I have any problem

And if we can do what to give after ftp>open

when I give my System IP to get connected it gives connection fail.

Is it possible to do reverse ?

I mean I want to do FTP from Windows client, to Unix server. But can I do import of file by opening FTP in Unix and get file from Windows Client ?

This is in continuty of Unzip in DS post.
Thanks

So I have to write a UNIX script rite ? That means that I need to do FTP from Unix and act Unix as my Local machine and my PC as remote rite ? But then when I use FTP in unix what shall i write in Open to ?

Thanks I got it. But I want to make this automated to unzip. Is there a way in Datastage?