DSXchange

Hi,
FYI.The problem was resolved, the default setting for APT_DUMP_SCORE is True in QA, but False in DEV. The job that encountered the PID error was attempting to override that setting to False.

Hi, We have a sequence which calls only one job and it works fine in dev. Once we run the same in QA environment, it aborts with just 2 lines of messages 'Job control process (pid XXXXX) has failed' Tried the same job with a new sequence and it aborts but the job runs fine by itself. The job does ha...

Hi ArndW, I used the replace function and I was wondering if we could have handled it in the StringfromDecimal function, thanks for the information.

Hi,

Converting a decimal to string (reading from teradata source, writing to XML file),

TgtCol:String[10]=string_from_decimal[fix_zero](SrcCol)

SrcCol = 2.56


The result os ' 000002.56' is there a way to avoid the leading space and have a 0 instead?


Thanks,

Hi,
Is there a way to avoid the space before 007654321

Using DecimalToString(ColumnA) function produces: A, 007654321,X


I am able to do it with a transformer but would not like to have the transformer just to trim one field.

Hi Ray,

Have a job that runs everyday, reads from a table and writes to a file. Now it needs to append the date to the file name (OutputMMDDYY) every run, is there a way to do it without using the routines.

We are on 7.5EE.

Thanks,

http://blogs.ittoolbox.com/bi/websphere ... 008120.asp this is the blog link.

Hi,

How about making the source column (rel_name_rel_key) definition NULLABLE and let the Modify stage handle the Nulls.

Also trim the source column for blanks and spaces(rel_name_rel_key).

The basic transformer.

Thanks,

Right now using FMT(SrcColumn, "2'0'R") , wil post it if I come across any better ideas.

Thanks for the inputs, when I used PadString() its padding at the end so its making a 1 to 10 , I was expecting 01 !

How can we convert an integer to string, we have source column as 2 , and we need it to be padded with 0s for lenght of 3 i.e. 002.


Thanks,

Got this one!

Got it !

Hi ,
The reason I asked this instead of going to the manual is , if we use the Teradata EE stage to read, it is trying to create the temp terasync table and the same read from teradata API stage does not, tried to look up the manul but could not find the difference.


Thanks for all the inputs.