DSXchange

hi

i get a field with values like

8803981188PCLAW018803981188PCLAW01
MMNQ1MMNQ1
TTHQ1VGTTHQ1VG

how do i neglect the second set of duplicate string from the above using transformer?my output should be somethng like

8803981188PCLAW01
MMNQ1
TTHQ1VG

Thanks

hi i have a string like 87658799_qw456huji78_AT_TIME1 i should extract the first '_' delimited field from the string i.e. 87658799 how could this be done through a transformer. can some1 provide the exact function. and also the first '_' string may have any length. nothing can be considered as a con...

hi, i have a sequential file stage with input columns : status varchar completed_date timestamp the column status will have value as 'S' and 'C'. i want to pick the maximum date from the completed_date column with status as 'C' and load it in the target file. i used the logic of filtering the column...

I need to use regular expression to strip words from the i/p sequential file stage using regular expression. which stage in datastage can be used for regular expressions?

how do i create a perl script that hits my webservice and passes i/p to WISD stage as an xml input

You can't. An External Filter stage requires both an input and an output link. Try thinking about other stage types, perhaps an External Source stage. ... I have to filter the regular expressions using an external filter stage, and get the o/p in a sequential file stage. what type of script should ...

how can i pass inputs to my job by calling a perl script in external filter stage.

i need to call a procedure at the odbc stage of my job at the open command. this procedure will truncate the table mentioned in the odbc stage. give me the exact syntax to call the procedure at open command.

Whenever a *.so file can not be found, in my experience, the problem is almost always an improperly-set shared library search path - the environment variable LD_LIBRARY_PATH, SHLIB_PATH or LIBPATH, de ... hi im nt a premium member yet so i cant view the latter part of ur post..can u please post the...

the job has i/p as sequential file stage. it take a dat file as i/p validate it againsta an xsd an load it in db. in this case the i/p file may contain japanese characters. can u please elaborate on the NLS_Lang parameter for oracle db?

when i run parallel jobs with 2box2node configuration or 2box4node configuration. i get the following errors. node_node5: Warning: library "dsjobsh" failed to load: Could not load "dsjobsh": libACS_client_cpp.so: cannot open shared object file: No such file or directory. CRCAccou...

i prepare the *.dat file using textpad editor. does the font also matters? because only few fonts like arial unicode and ms mincho supports japanese characters.

i have tried with shft JIS NLS settings also but the data in DB are reproduced as error characters.(square boxes)

Hi,

has anyone tried loading data with multi-lingual characters like japanese or chinese through DataStage jobs into Oracle DB. the data should be in a dat file. rcommend procedures to create multilingual data and loading it in DB.

thnx

how to enable the jobs reset option in the jobs(parallel and server), so that it gets reset everytime after an abort?