DSXchange

Try giving the schema along with the table name.

There seems to be a ftp config problem on the unix side.
PASV mode in ftp is usually used when accessing through a firewall.
May be the PASV mode is disable by your admin.
Request him for details and let us know.

GL

What kind of date transform do you need ? There are many ways. You have routines in the SDK, you can write your won server routines, have a shell manipulate the date as a before job routine. Advice: Research the manual, you will find alot ways to do that. Moreover the forum is rich with such questio...

To add on:
Instead of SQL SERVER mentioned in the .odbc.ini and the uvodbc.config you can have the desired name of the connection.

Please restate the problem if possible.

I dont mean to object on english being your second language.

There are many ways done in Server to resolve the Duplicacy issue. If you give a search you should be able to find routines written by the posters. Click HERE

In parallel there is a remove duplicate stage.

Good luck

There is some problem in your routine.
As Andrw mentioned you need to debug it from there. There doesnt seem to be any problem in the job.
May be the sub-routine is doing a DB call or running some procedure that is resulting in a deadlock.

Memory space error in which kind of job. A job that is writing into a Seq file, a table, etc.

Please give details. Posting such statements would lead no one anywhere.

If you have an oracle source or any DB table then you can filter within the select statement. To find if there are any duplicate values in TABLE_B alone (if there is a primary key then there will be no duplicates) type the following: SELECT COUNT(*), COLUMN_A, COLUMN_B FROM TABLE_B GROUP BY ...

How exactly are you doing your insert and updates.
Does the error response come after you stop the job or while it is running and it returns and error.
Can you post the exact error from the log as well.

Routines in DataStage are nothing but lines of Universe Basic Code. Get any guide that outlines help in Universe basic and you will get the hang of it. There are plenty of basic routines on this site as well, which have pretty good documentation. Have a strong cup of coffee, search and go through th...

See, i am not exactly sure about datasets. Never faced a problem as such. Think we need some more experienced advice.

Cant you use unix rm command. I am not exactly sure with PX datasets weather you require orchadmin commands or just the unix rm command would suffice. Can you go in the command line and try deleting one file ?

Offcourse you can. You can clear all files, even delete them at the unix level. For log files, there was a job on ADN that was built to clear all the log files. I am not exactly sure if its still there. 7 days is just a suggestion, you can do it 10 days, 15 days, whatever you like. Its known as the ...

When you hit run, a window appears, you can set the warn limit there in the gui representation. From command line you can use