DSXchange

bandish

In the routine I can use the following functions to fetch log entries: 1. DSGetLogEntry Function 2. DSGetLogSummary Function 3. DSGetNewestLogId Function But in a particular job there can be multiple fatal errors. So, how to fetch the exact EventID for fatal error which has the Error code : 1017 and...

bandish

Hi, I need to populate two columns ERR_C ERR_MSG_T ERR_C will contain the error code describing the exception condition which caused the job to abort. ERR_MSG_T will have the error message of the exception condition which caused the job abort. For example: ERR_C=01017 ERR_MSG_T=Invalid Username/Pass...

bandish

My requirement is String Replacement. So convert will not work.

For Ex:

Replace "ABC" with "PQRST"

Input String: ABCXYZABC
Output String: PQRSTXYZPQRST

bandish

We should have a function similar to Ereplace in Parallel jobs too .. ! So there are two options to implement it: 1. Use Basic transformer in Parallel job. 2. Write a parallel rouitne in C to accomplish the same. Option 1, Basic transformer will slow down the performance of parallel job, If I am not...

bandish

Do we have a function in Parallel jobs to replace every occurrence of a string with replacement string?

Example:

Replace "ABC" with "PQR"

Input String: ABCXYZABC
Output String: PQRXYZPQR

bandish

bandish Posted: Sat Dec 23, 2006 6:57 am -------------------------------------------------------------------------------- I would like to know, why DataStage is unable to identify a TIMESTAMP(6) column while importing metadata ? If Datatype of this column is specified to TimeStamp, Length = 38, Sca...

bandish

Database is Oracle 10g.

bandish

I would like to know, why DataStage is unable to identify a TIMESTAMP(6) column while importing metadata ?

If Datatype of this column is specified to TimeStamp, Length = 38,
Scale = 6, we are able to view data and run our jobs.

bandish

There might be NULL values in the input column.

bandish

Hi, In the Database we have Timestamp Fields with Datatype TIMESTAMP(6). When I imported this table definition to Datastage using Datastage Manager, it got Converted to Unknown Datatype with Length Not Specified and Scale = 6. Now when we try to view data from this table in datastage, we get the fol...

bandish

Hi,

Can we write a script to assign default value to Datastage ENVIRONMENT variables?

If yes, then is it a good practice or not ?

Bandish

bandish

No its still pending !
Just trying out by decreasing the size of my original xml file.

bandish

Format details are as below:

Code: Select all

Record Level
Final Delimiter = none
Record Delimiter = null

Field Defaults
Delimiter = none
Quote = none

Thanks
Bandish

bandish

I am able to run the job and load into a dataset using xml doc provided by you !
I think you are missing something in the format tab of source Sequential file.

Thanks
Bandish

bandish

On the Stage --> General tab , have you checked the options to not reject fatal or error records. I think thats why you are not getting any warnings.

Will try the design suggested by you.

DSXchange

Search found 41 matches

Capture Error Message in Server Routine (Transform Function)

Function to Replace a string with replacement string ?

TIMESTAMP(6) converted to Unknown while loading Metadata

Script to assign default value to an ENVIRONMENT Variable?