DSXchange

its actually a parallel job.

Hiii guys, I tried to insert data into the oracle table using oracle enterprise stage. I used both Upsert and Load method. When I use the Upsert method the data gets loaded and the job runs fine but when I run the job using the Load method with index mode rebuild, the job dosen't abort but the data ...

Hiii Ray, Sorry For late reply and Thanks for the reply, I tried and it worked. The reason my file was restricted to 3 names, was jus for learning purpose and trying to figure out concepts behind these rules set. Also, attended DSXchange's first webinar Congrats . It was unfortunate that it ended wi...

Hello,
I'm facing same problem, does anyone have workaround.
Thanks - gsym

Hi, I am relatively new with Qualitystage and got some basic questions regarding creating custom rule set. My ClS file ;;QualityStage v8.0 \FORMAT\ SORT=Y AARON AARON F ABBEY ABBEY F JOHN JOHN F My DCT file ;;QualityStage v8.0 \FORMAT\ SORT=N ;--------------------------------------------------------...

Got, It - Thank You

Hi,

I tried,

filepath/test.sh filepath/filename.txt

Now I got the output from compand as 0, but reply is 1 now (and got warning) and job got aborted.

Thanks - gsym

Hello, I have a script, test.sh ======== #! /bin/ksh if [-s $1] then echo 0 else echo 1 fi ======== When i execute it I'm passing parameter (a filename). > test.sh filename.txt Everything is fine, the script returns 0 if the file has any data and vice versa. When I call the same script in DataStage ...

Hi,

To split the time part alone as per your Date format, try Right function

Right("1/28/2008 1:46:55 PM",10) will result - 1:46:55 PM

Thanks & Regards - gsym

Kris,

At present iam looking for a close value for the No of days.

But, the problem is with the rejected records.

why The records with DOB as 01/03/1968, 01/12/1968, 01/06/1968 are getting rejected though they are valid (greater than 16 yrs and less than 85 yrs)?

yes, the logic is
If(@DATE -
Iconv(ToTransformer.BIRTHDATE,"D/MDY") > 5840 AND @DATE - Iconv(ToTransformer.BIRTHDATE,"D/MDY") < 31025) then 1 else 0[/quote]

kris,

I tried with system variable @Date , still the same problem........

Hi All, I have a problem while manipulating the date. My source and target are DB2 databases. Job Design is DB2 API --> TRANSFORMER -->DB2 API -->DB2 API (reject link) Here is the logic iam using to find whether the age is greater than 16 yrs and less than 85 yrs. Created a stage variable DOB with t...

Hi , Defined the User Defined Environment Variable for NLS_LANG and for LC_CTYPE in the Administrator for the project. Set the values to $ENV . Added the parameters in the jobParameters and override the default values to AMERICAN_AMERICA.UTF8 and C.utf8. Still the same problem... dsenv template is #...

Hi,

Can anyone help me to solve this problem..

Thanks