DSXchange

Dear experts,

Thanks a lot for your kind replies and time.

Kind Regards.

Craiga and Ray thanks a lot for your time and reply. Basically, I'm running a sequence and this string parameter value is an input to one of my jobs in the sequence. If by mistake the production team misses to provide the string value the job would abort. Is there any option in Director/DataStage to...

Dear Experts, In one of my jobs I have defined two parameters 1. CUST_ID - integer data type. 2. LOC_CD - String data type If I try running the job without giving any value for these parameter (at run time), I'm getting a small pop up window against CUST_ID as below: Error: Request CUST_ID must have...

Dear experts, I'm trying to use SCD stage in DataStage Version 8.1 for the first time. I'm getting the following compilation error Invalid derivation for the SCD type 2 expired date column 'EXP_TMSP' - the correct derivation should be either a literal or SetNull() function call. Initially I searched...

Hello all, I'm trying to implement SCD-Type 2 using SCD stage. (Version 8.1). Details: Source, Reference and lookup - DB2 tables source table has only one key column CUST_ID, generated by DB2. Reference table is not defined with any key column. But as per the business rule, If SourceTable.CUST_ID=Re...

Hello Ray, Thank you very much for your time and solution. I have suppressed my warnings now. For the benefit of anybody who is facing similar issue: Steps to change Warnings to Info:(These steps are recommended only if the warnings are informational. Not for real warnings! :wink:) Step:1 - Goto Dir...

Hello Klaus Schaefer thanks a lot for your valuable suggestion. Sorry for the confusion. Actually I'm using a DB2 Connector stage Under DB2 UDB category prior to DB2 API. The final stage in my job is a DB2 API stage referring to a different table. The table details given in DB2 connector stage meta ...

Dear Experts, I'm using PX Version 8.1 and the following warnings are shown in the Director log against my target DB2 stage. DB2_TGT: [IIS-CONN-DAAPI-000253] Writing the WCHAR column CUST_ID into a CHAR database column can cause data loss or corruption due to character set conversions. DB2_TGT: [IIS...

Dear all, I'm getting the following error message when I try to compare two different jobs (Right click on the job and selected "Compare against..." option to do the comparison.) within the same project and both the jobs under the same folder. "The '$' character, hexadecimal value 0x2...

Dear all, I have resolved this issue. :D I did the following: Step:1 Included two transformers Source column CRTDST_DATE - Varchar(10) Nullable YES TRANSFORMER1 ------------------- Stage Variable: Definition: svValidYMD char(10) Stage Variable Derivation: (Trans1Rec.CRTDST_DATE[1,4]:'-':Trans1Rec.CR...

Hi Jack, Thanks a lot for your kind help and time. I tried this logic. But as my data is really bad I was not able to get the desired output. I tried this way: Stage Variable : svValidYMD Stage Variable Derivation if IsValid("date", TransRec.CRTDST_DATE[1,4]:'-':TransRec.CRTDST_DATE[6,2]:'...

Thanks a ton for your time and replies. Sainath, our requirement is, any format other than "yyyy-mm-dd" is invalid. To locate the position of '-' I can think of the following: using 3 stage variables svDate=Left(TransRec.CRTDST_DATE,1,3) svMonth=Left(TransRec.CRTDST_DATE,4,6) svYear=Left(T...

Dear experts, The date value from source is expected to be in "yyyy-mm-dd" format. But one of the source files has different formats "yyyy-mm-dd", "dd-mm-yyyy", "mm-dd-yyyy".(Mixture of correct and incorrect formats). I'm trying to eliminate the incorrect form...

Ajay, thanks a lot for your time. Craig, thanks a ton for your time and guidance. First of all I apologize for my late reply. I have used the below derivation and my job works fine now. If EFF_DT = '' Or Not(IsValid('Date', StringToDate(EFF_DT , "%yyyy-%mm-%dd"))) Then 0 Else 1 Thanks agai...

Hello Craig, Thanks a lot for your valuable time and help. I tried different probabilities. using stage variables: Derivation ------------------------ ------------- EffDtValidate - Integer -2 If IsValid("Date",EFF_DT) = 1 Then 1 Else 0 ExpDtValidate-Interger-2 If IsValid("Date",E...