DSXchange

Hi Team I never worked on SQL server :| and current requirement is using a SQL server Procedure to fetch the data from DB and generate 3 output (with different metadata called dataset, this is same as if we run the 3 sql one after another). My requirement is to read all the output and do some manipu...

It will give warning because source is 24 and we are truncating data to 8, better use the substring functionality. var = trim(input)[1,8]
I hope, we will not get more than 8 char in input

Just one addon to ShaneMuir solution -
You need to add 0 in your minutes and seconds if they are single digit, So add zero by checking if len(val)=1 else val

Thanks Ray for your comment. I am closing this thread now.

Thanks Ray, Yes we can do that by using two lookup stage, which generate two reject.
So this mean we can not do that in single lookup stage, any other thoughts guys

Hi team We are using lookup stage with 2 reference data (both are quite small) and collecting reject, now we want to enhance this job by adding the logic to get due to which reference data the main data got rejected, currently I am doing that in transformer. I am curious if we can do that in lookup ...

When your job is picking last value , it is picking "\n" (new line char) also, please eliminate this before passing to your job. You can do this in command activity or Loop activity

This error is basically comes when Datastage is unable to write the job log into its file. So try to take a copy of current job and run. Hope this work !

Seems need to do the same. Between anyone else want to share something on this.

HI Guys, While installaing DS on WIndows Server 2008, somehow we have missed to install C++ compiler before Datastage installation. We have installed it after the DS installation and setup all the env variables but Datastage did not pick up the C++ compiler. Can we have some tweak regarding this wit...

Thanks Ray. I got the Warning, Now Job is fine.

Hi Team My parallel job is giving below warning : APT_CombinedOperatorController(4),1: Conversion error calling conversion routine decimal_from_string data may have been lost I know, this warning is generated when Job is doing conversion from string to decimal and something is preventing them. I hav...

Yes, Use of basic transformer in parallel job have some drawbacks but It DEPENDS.. About your questions - No, It is running Parallel ( by default ) as well as Sequencial. The Only drawback is It will invoke the SERVER ENGINE for executing the BASICs function used in BASIC transformer. px version of ...

Hi I have tried to use the External Filter but still I am getting the same error. main_program: APT_PipeConnection: new connection 1 requests file descriptor -1, which was also requested by connection 0 main_program: Fatal Error: Incompatible connection - operator type = APT_OSL_SubprocOperator ( I ...

Hi Team I am getting below Error when using a External Filter Stage in one job. I searched on Google and DSXchange but not able to find much help. Can you please help here ... Error : main_program: APT_PipeConnection: new connection 1 requests file descriptor -1, which was also requested by connecti...