DSXchange

Hi, I will describing the process below please let me know where the problem might be: We have a update surrogate key job which updates the state file with the maximum value in the target table. Before it updates the statefile, in before job subroutine this job runs a touch command with the state fi...

As mentioned above i am creating this in user variable activity.

Then time will have colon in it

How are you generating DATE and TIME in user variable activity.

This should be generated during run time

Hi, I want the sequential file name to have Date and Time in the following fomat. 20110610_124801 I am creating this as a variable in user varaiables activity and passing it is as parameter to job. I am using the following: OCONV(DATE(), "D4-YMD[4,2,2]"): '_':OCONV(TIME(), "MTS")...

I like then without the scientific notations.

Like this format 100 or 0.78558

Not with 10000E+2

Appreciate help.

Did search but could not find anything suitable for my needs.

I am thinking the only way i can do is to convert to a decimal.

I would like to know which function can be used. And what should be the length and precision of decimal in order not to truncate any data.

Appreciate help on this.

Hi, I am reading from db2 table having column datatype of type double 8. When i import table definitions the DataStage takes this as double 53. When i query the table for the column i see values like 100 6.94391376623802 0.638014075806097 But when i see extracted data in a sequential file in unix i ...

So, what i understand is if i use Convert (@FM,char(13),column_name) --> Recommended Convert (char(254), char(13), column_name) --> Not recommened I shall be able to convert "Field Mark" to New Line Character. I dont have access to Datastage right now. Please correct me if i am missing som...

I can use the convert() function. But i don't know what is the offending character.
on Unix when i do octal dumb "od -bc" for that character i get a value of 376.

Help is appreciated to convert this offending character to new line character.

Gurus help is appreciated on this.

What happens when you set 'Preserve' to yes? When i set preserve to Yes. The next job reading this file thinks as multiple rows because the column has new line character in it. Also my job creating the file is server job. But the job reading the created file is parallel, so earlier i posted this in...

Hi, Trying to Accomplish : To load a complete sequential file into one column of table. For this i am using Folder stage to read the file, load the entire file in to the "RECORD" column of the sequential file. I have used the option of Preserve CRLF as "NO". Since i want this as ...

Also tried using Record delimiter in the parallel job sequential file
as
Record delimiter =UNIX newline

still does not work.

cannot see data in view data

The line terminator option is already set to Unix Style as server is on unix.

This is for the sequential file on server job.