DSXchange

To see whether you have same columns listed on Source inputs stage and Target output stage.

thanks,
Tom

Hi, Would any one let me know how to parse files name on input file stage in a sequential file stage? Say for example source file names are: file1_20040825_132154.txt file2_20040418_211536.txt etc. There a bunch of files in the source directory and I don't want to pass each file everytime. How can t...

If someone has deleted jobs by mistake. You can import Data stage job components from backup repository if you have exported them into a .dsx file.

thanks,
tom

I got it now....I converted data type of this time column to Char while loading in. But the target table has time format only.

Target database is Teradata


Thanks,
Tom

I Tried ICONV and OCONV for time conversions. Even then I am getting this error:

Attempt to convert String value "xx:yy:zz" to Time type unsuccessful


thanks,
tom

Please let me know. Input is String format of "xx:yy:zz" and want to conver to Time format to load into Database table with xx:yy:zz

Any Idea?


thanks,
Tom

It's giving error: Conversion from string value to Time type unsuccessful

Any other idea would be apprciated.

thanks

Hi,
I have an input text file with a set of columns and Time is in "xx:yy:zz" format. I want to load this char format Column to Time format column. How to accomplish this?

thanks,
Tom

You can not retrieve from repository unless you exported the job executable.

thanks,
Tom

Hi,
Just check if you have checked the fixed_width columns on the "Format" tab of outputs link tabb.

If you have more than one column and if you checked in the above option, you should choose "Retain" on the incomplete column tab in "columns"

thanks,
tom

Archives the log after the execution of job to a separate directory....


thanks,
tom

Hello, Yesterday also I posted my issue. But may be I have not explained well. Our problem, we have a set of jobs that run at the same time. In the sequence, we have a sequence and command stage to archive logs. When this job is archiving data to a subdirectory, another sequence also tries to archiv...

Try to run with Correct UserID and Password to open the UV File.



thanks,
Tom

Hi,
I have trouble with archiving Logs for various jobs. Job is trying to archive before it finishes its run. This causes the archiveLog failure thus aborting the job.

What's the good way to do archives for a job?

thanks,
Tom