DSXchange

You are correct, I intended to say CLEAR.FILE.
I will do a batch job from Windows to delete.

Thnak you for your quick response.

What is the correct process to delete &PH& files from a project.

Windows delete command or delete.file &PH&

I used link collector stage to accomplish this.

Thanks.

I have to concatenate 10 mainframe files into 1 sequential file. How do I accomplish this?

Can I accomplish this thru Job Control or using a link collector stage? How?

I am using Datastage version 7.5.1 on windows.

Thanks.

I did a BINARY FTP and chose EBCDIC dataformat and it worked.

ArndW and ds_developer - Thanks for the help. Appreciate it.

I am using DataStage Server Version 7.5.1. on Windows. One of the FTP'd file from mainframe has one field as Packed PIC 9(10) COMP-3. When I use this file in the CFF Stage, CFF stage is not converting it and shows some incorrect value. I am using this field as BINARY (6) in the CFF stage. I tried ri...

Are there any disadvantages/known issues, if Sequential Files are used as intermediate files for large volume data in DataStage PX jobs?


Thanks in Advance.

ArndW wrote:Use the orchadmin cp command from UNIX to copy datasets. By using a new APT_CONFIG file you can also change the location (and amount) of data files.

Thanks Arndw.

Hi all,

Is there a way to archive the DataSets from one UNIX directory to other UNIX directory, without corrupting the DataSets?

Thanks in Advance.

:!: Note: This function (Trans()) is available in job sequence expression derivations, not in parallel job expressions. The OP specified job sequence. The function is documented in the DataStage BASIC manual. It does the same job as UtilityHashLookup() but far more efficiently. Ray, I tried to use ...

Thanks csrazdan.

I am familiar with querying the Administrator for the Job Category.
But I would like to display the Job Category in a Sequence EMail Notification message, rather than querying from Administrator.

Is there any DSMacro or System Variable to get the Job Category?

For getting the JobName we have DSJobName, iam looking for a similar thing for getting the Job Category.

Thanks in Advance.

Thanks Guys.

Thanks Rob, Sorry for not mentioning it before. We are moving from SQL server to Oracle, This job is working file while reading the same fields and concatenation. This issue came up while reading the data from Oracle. We used concatenate in many jobs, I am looking for a easy solution, so that I don'...

Hi, I am selecting two fields from Oracle 10G database using ODBC stage and trying to concatenate them in transformer stage using ":". Issue is output field is populated only if both fields have values in it. One of the field is empty for some records. Please let me know what is wrong. Tha...