DSXchange

Hi, In transformer trying to check a condition on date in IF condition as below Date_column_input = StringToDate('1999-12-31',"yyyy-mm-dd") and getting below error: APT_CombinedOperatorController,0: Operator terminated abnormally: Terminating with exception:APT_ParseError: Parsing paramete...

Hi need to subtract one day from given date in transformer, dont want to use OCONV , ICONV.


Date - 1 gives complilation error as "Invalid conversion requested from a dfloat to a date."

Do we have any default parameter set in Datastage 8.* versions? e.g. say we have a parameter set "ConnectionName" with parameters "Username" and "Password" so in scripting we can assign a value to these parameters as below: "ConnectionName.Username" = 'ABC' &q...

Here is the scenario, In a restartable sequence which will on failure sets a checkpoint and in subsequent run starts from that checkpoint. If we plug a exception handler, then the checkpoint is not saved on failure and in subsequent run the sequence will start from scrach. I have few jobs which need...

Getting below error while doing update then Insert in oracle stage, Any suggestions

IIS-CONN-ORA-001002] The OCI function OCIDateTimeConstruct returned status -2: OCI_INVALID_HANDLE. (CC_OraRecordDataSetConsumer::writeBindBuffers, file CC_OraRecordDataSetConsumer.cpp, line 1,782)

No, This Job is developed in same project.

Need to remove Pivot warning as "Bad NLS map name "" specified" Also for Lookup stage need to remove the warning as "When checking operator: Operator of type "APT_LUTCreateOp": will partition despite the preserve-partitioning flag on the data set on input port 0.&q...

df -a Datasets Filesystem 1K-blocks Used Available Use% Mounted on /dev/mapper/datastage_dg-tech_dsnode1 2064208 572584 1386768 30% /tech/dsnode1 This tells still 70% of space is available. If there is no limit on lookup stage then not sure why giving "No space left on device" message

anbu wrote:You dont have enough space in /tech/dsnode1/Datasets to write lookup file.Remove the old files from /tech/dsnode1/Datasets.

Use /bin/df to check how much free space is there in /tech/dsnode1/Datasets

Thanks, can please elaborate more on use of /bin/df

Is there any Limit on Loopupstage, in terms of number of rows.

Hi, In job doing lookup with .ds files using looking stage. Lookup has 5 million row , number of lookups are 2.


Getting error as below;

lkp_ISR_HST,0: Error writing table file "/tech/dsnode1/Datasets/lookuptable.20101011.mv1mb1b": No space left on device

Getting below error

orcl_ACCT_S,0: [IIS-CONN-DAAPI-000045] Can not convert to framework type timestamp (CC_PXAccessor::setCalendar, file CC_PXAccessor.cpp, line 4,137)

How to assign Value to Project parameter in any stage( say transformer)? Generally we will Assign it at sequence level.

1. Transaction Management. Are transactions always on a stage level? Is it possible for a transaction to span multiple stages and/or jobs? 2. Database connection/session handling. Is there connection pooling in Datastage? If yes, can concurrent transactions be prevented in a single db session? 3. Or...

yes i have more than one reference link, i am planning to use one lookup stage for one reference link and then carry forward result to 2nd lookup with 2nd reference link