DSXchange

Hi Nripendra,

I am getting the same problem like padding of spaces is not happening for a charcter field in DB2 EE stage. If you have any solution for this problem. Please pass it, it will be helpful to me.

Thanks&Regards
Nagesh.

Hi,

Use the following rounding function in the transformer. It will give your expected result.

DecimalToDecimal(ColumnName,'round_inf')

Regards
Nagesh.

ray.wurlod wrote:Is EmpName a string[nn] (Char) or a string[max=nn] (VarChar) data type?

Hi Ray,

My attribute EmpName is Char Data Type and I am generating the spaces in the Empname data by using Row Generator.

Thanks & Regards
Nagesh.

Hi Smita, I think in your metadata you have columns with Nullability YES in the Data set ( Source). So, you have to handle this nulls while you are using Sequential file as Target. Just try this out , go to the Sequential file Metadta and select the columns which have the Nullability YES and double ...

Hi vmcburney

I tried the function mentioned by you

Empname= string_trim(Empname)

still i am not getting proper result. Its not removing the Trailing and leading spaces.

Regards
Nagesh.

Hi Rgandra,

I tried out the function mentioned by you

Empname= string_trim[" "](Empname)

But i didn't get the proper result.

Its not removing Leading and Trailing spaces.

Regards
Nagesh.

Hi,

I think one of your job was not in a runnable state, means one of your your job is not in Compile position,either it is in Abort position or Not compiled position. So , check the position of your jobs if its not in compiled position compile it.

Regards
Nagesh.

Hi,

Just try this out, do the hash partition in Sortstage and select 'SAME' partition type in Remove Duplictae stage. I think it will solve your problem.

Regards
Nagesh.

Hi,

Further Inputs from my side.

If you are doing Hash Partition in Sort stage then keep 'SAME' as a partition method in the remove duplicate stage.

Regards
Nagesh.

Hi Ray & Arnd,

Great Inputs .

Thanks for your Inputs.

Regards
Nagesh.

Hi Keshav,

I dont think so , it is a problem with Dataset. In our project we have 200 columns in different datasets.Its running smoothly.Check the environment varibales if any to get the ORCHHOME limitation in your project level, override the default values.

Regards
Nagesh

Hi Ananda, What Force option you selected in the Copy stage after Teradata stage? If Force=False make it Force=True then copy stage will work as a Optimiser. I think it will solve your problem. If your doing the above one already then think about Lookup, lookup reference file unable to store the hug...

Hi All,

Thanks a ton for your inputs.
Now i am able to see the DS_AUDIT table in the TCL server.

Is it possibel to get this details in the Text file by using Shell script ?

If so suggest me how to write the shell script to get this details ?

Thanks & Regards
Nagesh.

Hi Ray & Arnd, I executed the query in TCL but i am getting following message : sac@lpar5m:/dstage/dsadm/Ascential/DataStage/DSEngine:$ . ./dsenv sac@lpar5m:/dstage/dsadm/Ascential/DataStage/DSEngine:$ bin/dssh DataStage Command Language 7.5 Copyright (c) 1997 - 2004 Ascential Software Corporati...

Hi Ray, Thanks for your reply. You gave me good information regarding DS_AUDIT table. But, as of now i don't have Administrtaor Privileges to perform this query. Can you suggest me how to get the same information as developer point of view. Presently i have access of DS designer and Director. My ope...