DSXchange

Thanks to all the experts for your wonderful insights ..I will keep you posted with the updates...Still we are working with DS Admins and we are planned to reach out to TWS Admins too

Thanks for response Paul .. TWS scheduler invokes wrapper script ...and this wrapper script mostly does nothing other than calling DataStage.We are experiencing this since almost few months and I am 100% sure that datastage job never gets triggered when we found this 262 return/error code. At a sing...

Hi - Designed to run datastge job with TWS scheduler. Some times during the scheduled runs our TWS jobs were getting failed with 262 error code but the actual job never gets triggered. below is the TWS log + /fsiis_h4/IBM/InformationServer/Server/DSEngine/bin/dsjob -run -mode NORMAL -jobstatus -para...

Hi, I have simple job, where i am reading excel sheet using unstructured stage and writing to sequential file. My requirement is get data as it is from excel to output which is CSV file.In the sheet two of columns have numeric data (cell format is general) and Issue was they are converting to expone...

Hi Ernie, I have used same WTXAccelerator.zip file from the given link from there I am taking WTXStage.jar file at classpath in java integration stage,but iam facing an error in datastage hipaa_837p_5010_flat,0: java.lang.UnsatisfiedLinkError: dtxjpi (The specified procedure could not be found. ) at...

Iam trying to integrate wtx in Infosphere datastage through Java Integration stage , Iam unable to locate some jar files in the system like while running the job with WTXStage.jar file , am facing an errors like MapAllTypes: java.lang.NoClassDefFoundError: com.ibm.is.cc.javastage.api.Processor at ja...

Hi Ray,

It ran fine after re compile.We are seeing this issue first time and never happened before to this job. We are trying to identify the root cause of the issue .
Can you suggest us what could be the reason?

Hi,
Thanks for reply.


This was first time fails and it ran successfully many times .
Job was hanged for 1 hr and later we got these errors.

Hi ,, We have sequence job failure and got below error. It ran fine once after compilation.We would like to know what would be the reason to cause the issue and how we can fix it. Sequence job : ExecCommand Activity (run sh program) --> ExecCommand Activity (run perl program) From previous run DataS...

prasson_ibm wrote:When is the interview?

Learn from Ray,andrw how they responded...don't discourage if some one genuinely wants to learn.

Resolved the ascii issue while loading char(15) column in db2 table using below changes.

Added Environment variable APT_STRING_PADCHAR=0X20
Called this Environment variable in the DB2 connector stage.

Hello, Ascii value is appending end of the data for the column .Can you help us how to remove ascii value using datastage. for example we are defaulting "1111" to db2 column which is having length of the char(15) then output coming as "1111+asciivalues. deafult env variable in our pro...

Hi all,


I am reading one columns as Binary(40) and populating into varchar(255).
I did n't find any function converting from Binary to Varchar.
Does any one know how we can convert Binary to Varchar.

Thanks

Hi All, I have developed parallel routinee and parameterized the directory of executable file (.0) in Libaray path tab in parallel routine as below #$DIR_MDM_ROOT#/#$DIR_DEV_PHASE#/#$DIR_WORK#/FirstNonNumPos_1.o. I am not able to complie the datastage job because of parameterized the directory of ex...

Hi All,

I have written C++ program to develop paralllel routinee.I would like to know we do i have to place the c++ program and command to compile the parallel routinee.Can you please help me ?


Regards