DSXchange

Many thanx for ur suggestions guys.

Naga.

Programmer Analyst,
Cognizant,
Chennai.

hi raviyn,

i understand that i cannot do thingz with a single job as u said.

But regarding ur answer for renaming i feel that this is not possible if my datastage server and the ftp server that iam accessing are on different system, is'nt that ???

Programmer Analyst,
Cognizant,
Chennai.

hey guys, thanx very much for those answers, that clearly explains about how should i go about doing thingz with an FTP Stage, still (sorry..) i dont think you have understood my question guys. I have an ftp server and iam ftping things to my local(that doesnt matter i know) but my question was to d...

No, that doesnt answer my question. if u can help me out by describing more on that or point me to some place where i can get more information.

please.

Programmer Analyst,
Cognizant,
Chennai.

Can anyone help me with this issue ? i have to develop a job that will ftp files from remote server to my local and also rename the ftped file once the ftp is done. like if i have text1.txt i ftp that to my local and then rename it to text2.txt on the remote server side. also it must be done for mor...

I have a date field in my sequential file in YYYY-MM-DD HH:MI:SS format. when i try to insert this record to my oracle table through OCI stage using my udf sql..which has statement like insert into datenew values(to_date(:1,'YYYY-MM-DD HH:MI:SS')); i get an error in inserting this way.. do help me.....

can you be a bit more explanatory about setting the environment variables

Programmer Analyst,
Cognizant,
Chennai.

when iam trying to connect to datastage 5.2 server running on unix through my client (NT Version 5.2) i get the following error. Failed to connect to host: 162.44.9.87, project: UV (The connection was refused or the RPC daemon is not running (81016)) Help me ASAP, thanks, Naga. Programmer Analyst, C...

I have a Datastage 5.2 server for unix installed in my network.i need to connect to an oracle instance available in the same network.what are the things that i need to do so that i can access the tables available in the oracle instance through datastage? currently iam getting a TNS could not resolve...

Many thanks for that.

Programmer Analyst,
Cognizant,
Chennai.

I need to fetch only around 1000 records from a table that has more than a lakh records.i fetch data from table using ODBC stage.How can i write a prestage sql to achieve my requirement.

Thanks,
Naga.

Programmer Analyst,
Cognizant,
Chennai.