DSXchange

Hi,

Apply condition if string is 00000000 then set as null else you can use tringToDate(DSLink77.AAA,"%yyyy-%mm-%dd ")

It will be great if you show command and error message to help you.

Did you set the dsenv path for that.

Thank Ray.

I wanted to create more sub categories and Datastage Client sometime very slow , So It is taking more time. This is the reason , is there any way is there in backend to create sub categories.

Hi All,

I wanted to create subcategories using unix server (not in datastage Client) under the below 2 categories.

COMM_DETAIL
DIST_INFO

Need to create Like below:

COMM_DETAIL
TESTING
INFORMATION
FINAL
DIST_INFO
FIRST_TESTING

Please tell me what is the command need to use?

Thanks.

I wanted to take list of all the jobs and corresponding category in the project. What command need to use.?

Hi All, dsjob -ljobs TEST I can see all the jobs under project called TEST but Category name (Folder) is not displaying . I wanted to remove some jobs from this project but without folder name it is very difficult to do it. Every time i need to fire DS_JOBS command to find category. select category ...

Thanks a Lot Ray.

Thanks Ray.

Please tell me the syntex or which keyword i suppose to use to make read this field as null, because my inputfile does not contains emp_firstname value.

Thanks again for helping.

Thanks a lot Chulett. At present I don't have datastage access. What I am trying to ask is If I write schemafile like below , then first 5 digits assign to emp_id an next first characters will assign to emp_firstname. Is that correct? emp_id: decimal[5,0] {width=5}; emp_firstname:nullable string[5] ...

Schema what I provided is giving error message: record {record_delim='n', record_length=fixed, delim=none} ( emp_id: decimal[5,0] {width=5}; emp_firstname:nullable string[5] {width=5, null_file=' '}; emp_lastname:nullable string[5] {width=5, null_field=' '}; ) Otherwise , Please help me how to achei...

Hi , In my input file contains only emp_id and emp_firstname and there is no value for emp_lastname. Input file as: 12345James But I need to create ds with emp_id , emp_firstname with value and emp_lastname with null value. schema file contains : record {record_delim='n', record_length=fixed, delim=...

Hi ,

It depends on the stages used in your job and sometime it will slowdown the job performance. When we use more number of transformer stage , lookup stage this error will occur.

Try out this:

In Unix server fire the below command or use in ExecSH command in DSJOB properties.

awk ' NR > 2 ' Yourfile_name > NewFilename

use NewFilename for DataStage Job.

Thanks Arvind !

Server got restarted and now it is working. It will be very helpful to me if you explain why this error occured and we used to access until yesterday.