DSXchange

Hi chulet,

Thanks for you reply.

we made the version upgridation from 7.5.2 to 7.5.3

After changing the version to 7.5.3 its not working

can you please help me in this one

Hi all, I am facing a problem in datastage when i am using pivot or bulk load stage in my job i am getting below error and job is getting aborted. main_program: Error loading "@dscapiop": Could not load "@dscapiop": 0509-022 Cannot load module . 0509-026 System error: A file or d...

Hi ShaneMuir, Thanks for you replay, from the source itself i am getting hex '00' characters. So i have to trim those characters along with spaces. will the Datastage Trim function trims the hex '00' characters also? Can you please help me out to reslove this problem. Is APT_STRING_PADCHAR variable ...

Hi ray, Thanks for your help, To overcome this problem to which value i have to set to APT_STRING_PADCHAR variable. This variable will Overrides the pad character of 0x0 (ASCII null) If we set this variable to some other value will trim function trims the blanks also. I dont know exactly about APT_S...

Hi , from source i am getting hex '00' values instead of blanks. Can any one help me to convert hex '00' charcters with blanks I am not sure if trim funtion detect and trim hex '00' values I used convert function,but i am not getting how to represent hex '00' as a argument to the convert funtion. If...

Hi Mike,

I just saw the datastage help.In that one it says that empty is a numeric value.

Yes NUM function is giving warning with output as false.

can any one please help me how to check if the coulmn in numeric or not using other than NUM function.


Thanks for your help.

Hi Mike , Thanks for you replay From datastage help i came to know that NUM function will return true if it is empty. In the help its given like this. Arg3 = " " Boolean = Num(Arg3) ;* False (space is not numeric) Arg4 = "" Boolean = Num(Arg4) ;* True (empty string is numeric) Bu...

Hi all, I am facing problem with NUM function, My requirement is i have to trim the input value,after that i have to check if it is numeric or not. for this i gave the derivation like this. If Num(Trim(in_dataset.Member_Relationship_Cd)) then 1 else 0 when i use trim function along with NUM i am get...

Hi all, I am facing a problem with the decimal field having scale zero I am fetching the demial[15,0] field from db2 database using ODBC stage. when i am doing this one i got the warning as "TBL_SRV_REQ_CI: When checking operator: When binding output interface field "PRSN_ID_MEM" to f...

Hi all, I am running a parallel job and i am getting around 22000 rows from source.For testing purpose i want to limit the rows for which the job has to run. The row limit option ,while runing the job in director is applicable only for server jobs. can any one please help me in this one. Thanks &...

Hi I checked the LIBPATH it is /home/dsadm/Ascential/DataStage/branded_odbc/lib:/home/dsadm/Ascential/D ataStage/DSEngine/lib:/home/dsadm/Ascential/DataStage/DSEngine/uvdlls:/home/dsad m/Ascential/DataStage/DSEngine/java/jre/bin/classic:/home/dsadm/Ascential/DataSt age/DSEngine/java/jre/bin::/home/d...

Can you please tell me how to serach for library search path

Hi all, I created a c++ routine .i want to call that routine in datastage. when i am calling the routine the job was getting aborted. I am getting the below error. "Transformer_1: Failed to load the library "V0S1_swathi_test_Transformer_1.o"; either the directory containing the librar...

Hi all, I am facing an issue when comparing date fields. I am doing like this If Lkp_Read.EFF_DT_Target=Lkp_Read.EFF_DT_Input then 'I' Else 'U' Lkp_Read.EFF_DT_Target,Lkp_Read.EFF_DT_Input are two nullable date fields. If null is coming its giving warning as Tfm_2,0: Conversion error calling convers...

Hi WoMawil, sorry i gave the wrong output If the input is no -------- 1 1 1 0 0 1 0 1 i want output as no number ------------------ 1 1 1 1 1 3 0 0 0 0 1 2 0 0 1 1 i want the output as : if any of the zeros r coming i want the number of zeros coming sucessively plus after the which number its coming...