DSXchange

Hi all. I have created a shared container for my job. When i run the job, i got this error message from the DIrector. I could not figure out what is this error about. Hope to get some explanations or hints here. Below is the error that i got: node_node2: Fatal Error: Unable to start ORCHESTRATE proc...

Hi all. I am having problem in concatenating columns with the same field name from different tables in database. Let me explain in more detail. I am having three tables: ProductType, ProductName and FundType. Each of these tables is having a field called CODE. Now, I need to concatenate the CODE fie...

Hi ram1899. Thanks for offering help. I have some doubts here. Hope you can explain to me. Create a Job sequencer for the JOB you are running and call Execute_Command stage in it call the script in the execute command stage Do you mean I need to have a Job Activity stage to include my job. After tha...

I have been read through most of the posting regarding this topic in this forum. After reading all the postings, i have get some information and ideas on how to send an email notification and attachment. However, I still could not figure out how to get all the steps putting together to make things w...

Hi Ray.

Instead, run your parallel jobs from a job sequence (or from your own Job Control code), detect whatever it is you need to in the controller, and sent notification from there.

May I know can i add attachment in the mail?

Thanks very much~~

Hi Chulett. I have read thru the discussion. You provided a line of code in your reply in the topic. So, do you mean i need to include the code in a routine in DataStage? Then it will work after that? Or I still need to do something else to get it work? Secondly, when do we need a mail client as i r...

I have read through some of the posts in this forum. I found out that we can actually download a third pary command line mail client to send email notification from dataStage? However, i am blur or not sure about the steps to accomplish this. Can anyone provide some guidelines for me? I would like t...

Hi all. My project plan to send an email to notify system administrator once an ftp file has been successfully loaded into DataStage. May I know how to generate an email notification in parallel job? and if we would like to attach a file in the email, what should we do to accomplish that? By the way...

I have tried to align the data to the length that I specified in the meta data. However, when I attempted to view the data, it prompted me an error message: UnableError executing View Data command: ##E TOIX 000159 11:35:03(001) <Sequential_File_0,0> Short read encountered on import. This most likely...

Hi. I still having problem with importing fixed width column data into DataStage. First of all, I would like to know if we are using fixed width when importing metadata, the column name must be the same as the width that we specified? Secondly, how about the data? All of them must be in the width th...

Thanks Rasi for your reply. The user permission might be the problem. But I try to open the file straight after i ran the job by using the same user id.

May i know is there other reason that will cause this problem?

Thanks! Cheers~~

I have created a job to import source data with some transformation. My output is a sequential file with the data formatted. I can run the job successfully. However, when I would like to view the file, I could not open it and getting this error message: Unable to access file: /source/TestFixedWidth....

Hi all.

May I know what is the way of importing data with fixed-width column?

I would like to check out the way to import the meta data with fixed-width column option.

Hope can get some ideas from all of you. Thanks very much in advance.

Cheers~ :D

oh, so if the datatype in the oracle is datetime for this field and my DataStage sequential file having varchar for this field, i still can successfully load the data into Oracle database? By the way, u mentioned that i can make the changes according during transformation. May I know which data type...

Thank you Rasi for ur reply. Would you mind explain further for this sentence: If you are viewing the sequential file inside datastage with timestamp as data type regardless whether it is in the correct format you can view the file. Do you mean we can set it to any type in order to view the data? Th...