DSXchange

Hi,

Before raise a queastion try to find the answer using help or refer pdf. Please dont ask these type of questions!!

Sura

Hi Friend,

Welcome to board.

Remeber, while raise the question rasie it properly. As of my understasnding you want to know about source file validation to ensure for current date file. Is is right?

Regards,
Sura

Hi, I set the environment variable as LoadFiles --> C:\DSJOBS\LoadFiles\ In the project level i set the default value as $PROJDEF for $LoadFiles. When i tried to read the data i am getting the below error. ##I TOSH 000002 09:08:40(001) <main_program> orchgeneral: loaded ##I TOSH 000002 09:08:40(002)...

arnie_nits wrote:Hi,

I have got a decimal field EXT_AMOUNT DECIMAL 11,3. I get the values as 00000000045.22 whereas I need them as 45.22. It is a file load.
Please let me know how to do it.....I have already tried a lot......

Regards
Arnie.

Hi,

You can use Fabs function in Trasnformer.

Regards,
Ram

Hi,

I need to create a sequence file in daily basic with current date as the part of the file name.

Eg: If i run the job today then the file name should be Out_12_01_08.txt

How to do this?

Pls help me.


Sura

SURA wrote:Hi,

I need to get the previous date (Current date - 1) in stage variable. How to get it. Pls help me.

Sura

I found the solutions.

DateFromJulianDay(JulianDayFromDate(Your_Date)-1).

Thanks for the efforts.

Sura

Hi,

I need to get the previous date (Current date - 1) in stage variable. How to get it. Pls help me.

Sura

Hi I need help on this. I have a date column in source yyyy-mm-dd. I want to minus three years from this date for my requirement. Is there any function to do this. ex: 2007-10-10 Minus three years means: 2004-10-10 How to get this. Please heplp on this. Thanks Pawan Hi, You can you like below. Date...

Hi,

Is there is any direct function to do Titel Case in Parallel Extender? If so pls let me know.

Eg:

Input
------
Hi how are you.

Expected Output
-------------------
Hi How Are You.


Ram

Are the columns nullable? If so, remove your population with CurrentDate and see if the error remains. ... Hi, Hope you are using Change Capture Stage for this. In some cases DS PX log will not capture the exact error. So what i advise you is, before you run the job check the following. 1. Whether ...

Hi, For join stage key column name should be same. You can use a modify stage to change the column name input column (Emp_id) to output column (Manager_id) and then you can use the join stage. Ram Hi All, I have a Parallel job where in I need to perform a join using join stage based on the Key value...

Hi, It might be bcz, in your previous stage there is some warning and DS try to find / resolve it. Ram Hi One of our jobs which is calling a shared container to generate a sequence number aborts frequently with the following warning and error messages. SCGenSeqNo.db2API_Max_Seq,0: Logging delayed me...

Hi Man, Just increase the Target column length (in the file) Precision by 1.It will work in both the cases (15,3) or (16,3) Thanks, Ram. I have a column A with value ( 8.0000) and Column B ( 21.4300) When I multiply Column A and B My value should be 171.44 but the answer I get is 171.50. The target ...