DSXchange

How can I mention the null field value specific to fields. In your target Sequential File stage, go to the Columns tab, right click on a column and choose 'Edit Row'. Then specify the Null Field Value for each column under the Nullable properties. As noted, specify the null field value for each col...

The problem is whenever I run this job in production environment, one or the other date columns is populated as null values, even though the source SQL table has data for all the date columns. What are some of the values being dropped? Is the complete record being dropped or just the column value? ...

Hi All, How can we get the system out from a datastage job in DS V 8.0.1 Regards, Murali Are you referring to the Std out stream from a OS level command? - Answered above Would you like to get the job completion code from invoking a DataStage job? - look up the dsjob command Are you referring to th...

@Vinoth: Yes, I've run a similar job having 1 parameter less. @Craig: Actually I've run a similar job which has a parameter less but the length of the parameters was greater in that job when compared to this job. what is the new parameter value (please give the details that Craig has already asked ...

That would depend on the underlying database that the Siebel application has been installed on. Setup the connections in your odbc.ini configuration file accordingly.

Does your company have any kind of an "Enterprise" scheduler? ... Craig, Other than DataStage Director, I am not aware of any other Enterprise Scheduler that our organization utilizes. Thank you for your help, Seyed Using an enterprise scheduler for your dependencies and scheduling would ...

:?: I have a situation where i count the records in a file and when the file is empty I need the count to be zero. But In DataStage it is not outputting anything. :cry: Please advise. Are you doing your counting in an Aggregator stage or outside of DataStage? Can you use an operating system command...

Both datasets are hashed and sorted on previous jobs. And in this job we keep partionned mode "SAME" both sides. Are you sure no other job is messing with your datasets after they are hashed and sorted in your previous job and before you read them in the curent job?What happens if you add...

hsahay wrote: APT_COMPILER=/usr/vacpp/bin/xlC-r
APT_LINKER=/usr/vacpp/bin/xlC-r

Is it a typo in your post or do you have a hyphen(-) in place of an underscore(_) ? I believe it needs to be /usr/vacpp/bin/xlC_r

Are you connecting to SQL Server or MySQL ?

You could ask the report to be sent in XHTML format or if the current report structure is fairly standardized, use a utility like HTML Tidy to quickly and easily convert your HTML into XML

You could use your favorite Search/Replace utility to change the parameter values in the dsx file before you import into your Integration Environment

kumar66 wrote: I have given Method = Write and Mode =Append.

When ever my job fails , it should not load the data already loaded. ...

Have you tried using the Upsert method?

Dinakar,
You will find everything you need in the Universe BASIC manuals. These are available on the internet at http://www.rocketsoftware.com/u2/pubs/library/