DSXchange

Hi,,

Are you using Basic transformer in your job design which is not suggested in PX environment..

Regards
Amitava

Hi,

Use Filter Stage.. See the orchestrate manual for proper syntax..

Regards

Amitava

Hi,

You can do by this process..

1. Find the current month number by the function 'MonthFromDate'.. If you give MonthFromDate(2004-07-15) , it will return 07, i,e July..

2. write your own logic (12 if-then else loop) to find the last day of the previous month..

Regards
Amitava Ghosh

Hi,

I came across this error when the input file does not exist or invalid.. The error does not says anything in detail..

Regards
Amitava ghosh

Hi,

For perfect result, You should use 'Trim' function before using 'Left' function because the argument is a string.. So your syntax should be like Left(Trim(string_var),1)

Regards
Amitava Ghosh

Hi,

Lookup will return all values..

Regards
Amitava

Hi,

Better if you use a join stage between the outputs..

Regards
Amitava

Hi,

You can use the Surrogate Key generator stage available in version 7.0.1

Regards
Amitava

Hi,

Use the Surrogate Key Generator stage available in version 7.0.1.

Regards
Amitava

Hi,

We also had the same problem regarding this APT_STRING_PADCHAR.. But Ascential has solved the problem with version 7.0.1.\

Regards
Amitava

Hi, Check the maximum file size in your system . As you are using unix system check with ulimit -a command. If the maximum permissible file size is less than your required file size then increase the size. If the file size is within the permissible size then add a resource disk in your datastage con...

Hi RStone,

If you replace the Basic Transformer by a PX Transformer then your 'SIGBUS'/'SIGINT'/Mutex error may not come into the picture. I have also faced the similer problem.

Regards
Amitava

Hi, This problem may appear anytime if you are using Basic Transformer in a parallel job in datastage 7.0. It is suggested by DataStage that instead of using Basic transformer, use PX Transformer. This is due to the fact that Basic transformer is not a part of orchestrate engine and for this you may...

Hi,, Set those 2 variables in dsenv file. Execute dsenv and restart the server. Hope it will work. Regards Amitava Ghosh Hi Folks, I'm trying to use environment variables with DataStage and I'm having a little difficulty that I hope someone can help me with. Background: I have a 'test' server job th...

Hi,

Set your environment variables in dsenv file. Execute the dsenv file and restart your datastage server. in dsjob command prompt define your environment variables like this..

-param '$ENVRNAME=$ENV'

Regards
Amitava ghosh