DSXchange

Hi
You may extract the source file by using sequential file??
If you using the sequential file we have Format Tab in sequential file
date/ Format string we can occur this .... or else better go by using transformer Below mentioned replies

Hi I am not able to run the job . while viewing i am able to view . i got this error APT_CombinedOperatorController,0: Fatal Error: Fatal: [IBM][CLI Driver] CLI0124E Invalid argument value. SQLSTATE=HY009 DSTAGE-DB2CLI-0005`:`Unable to connect to DB2 server 'NOTLIKELYDSCAPIOP_$MF_GADT_DEV_DBNOTLIKEL...

Hi,
By Using Filter,Transformer stages you can achive this

Regards,
Manoj

Hi,
By Using Filter,Transformer stages you can achive this

Regards,
Manoj

Hi Kumar,
I think in setting you may did some mistakes reset and try this
Thanks,
Manoj

it gives false (0).
I think you are discuss about null string .

Hi,
Instead of using this Surrogate key use row generator and give
Intial value = 1
Final value = 10000
Increment value =1
It will Satisfy your Requirement


Regards,
Manoj

Hi
In Server some functions are there like mca, ....
In Parallel you have to write routine
write server routine and call to this parallel job it will helps
Thanks,
Manoj

Hi
use timestamp with 23,3 it will works

Hi,
you can obtain this using this
If ( monitoring_flag <> 'Y' or monitoring_flag <> 'N')
Then SetNull()
else monitoring_flag

Hi,
This can be obtain
<File100records> + <Column Generator>
(Create a new column with datatype char and give Input as 1st value A,2st value B,3st value C,)

<Use transformer or filter or switch > and split A,B,C
you can obtain 3 Datasets us you Required
Regards,
Manoj

Hi,
I think we had meet this senerio instead of conveting into rows into colums and transforming .
<F1> and <F2>
<F2> use Transformer and split them into diff catageory
for eg 10 cat
Join all 10 cat with <F1>
u can get the Result

Regards,
Manoj

hi
you can boss include wat you hve to send to claint subject ;
Regards,
Manoj

Hi,

no DB2 functions are SQL and the Transformer uses C-Code (or Basic if it is a Basic--Transformer).

U can use stored procedure or u hve to write routine to obtain this

Regards
Manoj

Althaf6553 wrote:We are in process of finding percentage of number values in character field

Is there is any way to the same ?

If you are Using DB2 You can convert into nums and U can do calculation