DSXchange

so , when i read from a file which has some spanish characters, and if i set the unicode option in the sequential file stage . Is that enough ?

I have a issue with a degree like symbol used in spanish along with the address .

The input columns from the file is taken to be of unicode . So , if some special characters come in the file , they get translated to the NLS set in the project. But in the basic transformer in the parallel job , i could not see the extended option . Does this mean , basic transformers do not suppor...

reframed it for easy understanding......but i have not got any response for my problem.

Any thoughts as how to get rid of this issue ?

But the job throws errors for column not mentioned in the columns tab , saying that it has unsupported type

Hi , I'm trying to load data to ORACLE through the load option. I have about 6 columns to load but the table has other additional columns and one of it is a LONG datatype. The job aborts saying the COL1 datatype not supported. How can i avoid this as i'm not interested in loading that LONG datatype.

Hi ,

I would want to make the ORACLE enterprise stage to read in parallel from the source. But by default it is sequential. But i have a user-defined SQL which has many table joined.
SO if i include all these tables used in the SQL in the partition option would all of them read in parallel ?

Hi

In the sequence trigger i'm specifying when the script output is "ERR-0099" by Execute_Command_0.$CommandOutput='ERR-0099'

But the trigger is not getting activated even when i see in logs messages like this
Output from command ====>
ERR-0099

After setting the TMPDIR environment variable in each project , should the server be restarted for it to take in effect ?
Because i don't see any files created in the TMPDIR and still it created in /tmp directory only.

Hi All

We get the date time from the external system in EST format but would be required to store it in UTC format in the database . How can i achieve this ?

Can the NLS locale be of some help ? Or is there some setting to be done in Datastage to write it in the UTC format.

[/quote]to read the TZ environment variable. The latter will yield the time zone of the DataStage server. Ok. I do not get an extra field in my input data file so i would have to use the second method. My issue here is we have to store the date in the UTC format in the database. The NLS - Locale use...

Hi Ray ...

What exactly do you mean by detect.
From the timestamp , would we have to conclude if it is Daylight savings or not. and then apply the time difference accordingly ?

Thanks , i had used the same cating in the after job ExecSH option but wanted to know if there are any other options with the combinability modes available or any other properties with the stage itself.

Hi i have 3 seq file stage and all of them are in the append mode writing to the SAME file. So , when i see the director for logs For Seq 1 : it has x records exported For Seq_2 : it has y records exported For Seq 3 : It has z records exported But the count of records in the seq file is less than x+...

You might have to make the webspher user registry as active

You might have to make the webspher user registry as active