DSXchange

Thank You "chulett"

i am calling this batfile in a routine using "Call DSExecute("DOS","E:\DATAFILES\SOURCE\TBillTrxn_Batch.bat",Output,SystemReturnCode)"

This status i am taking in a stage varibale...

we dotn have any dstransform or commands to do this from job..

i am getting the status F or P in stage varibale this is ok.
My probelm is i want to abort the job if the status of stage varibale is F.

Vijay

Hi

i am executing one batfile if the batfile failed i need to abort my job i am able get the status of that batfile "F" or "P". i want to abort my job if it is "F"

Help me, Thanks in Advance


Vijay

Previously i didint put the reject link , after knowing from you i put the rejected link and again a run the job with some date now its not rejecting the records in second time run, previously also same thing if we run second time we can get that records, we are not able to find out root casue of th...

Previously i didint put the reject link , after knowing from you i put the rejected link and again a run the job with some date now its not rejecting the records in second time run, previously also same thing if we run second time we can get that records, we are not able to find out root casue of th...

Its not rejecting any records and No warning massages also

In Oracle Stage i coded user defied sql as update or Insert, but its not inserting the records, can any one help in this regard. This is my sql query UPDATE #$SCHEMA_DWH#.DWH_S3_TAHGRP SET END_ACT_CD=:9,AVG_SALARY_AMT=:10,TOT_SALARY_AMT=:11,HIGH_SALARY_AMT=:12,SALARY_BAND_CD=:13,SALARY_FREQ_CD=:14,C...

Today while runnin the sequence my harddisk full and than datastage is giving the following error "Error calling subroutine: *DataStage*DSR_SELECT (Action=3); check DataStage is set up correctly in project CRM_PROD (Subroutine failed to complete successfully (30107))" What i want to to res...

Thank you Joshy George

vijay

I want to remove the 0 if it is 4th byte from the given number.

Eg

123045678 -- i need 12345678
9870124 -- i need 987124
80124578 -- i need 80124578

Pls. help, Thanks in Advance

Vijay

Thank you Very much "Joshy George"

Vijay

Hi all

I want to extract the characters when ever the # is present in the string

eg

1. vijaykumar#121qq22342 --- i want vijaykumar
2. update#thesystem --- i want to extract update


pls help me in this, thanks in advance.

What about Leap year


Regards,
Vijay