DSXchange

We are using a lot of SP stage to call pakages and they just work fine. Never had any issues.

Or you can even use a simple derivation like

If Count(Column,'-') > 0 Then '-' : Field(Column,'-',1) Else Column

Or you can even use a simple derivation like

If Count(Column,'-') > 0 Then '-' : Field(Column,'-',1) Else Column

From whatever I think of, you can export the jobs and make this change in the dsx. For example, you column may be defined in the dsx like BEGIN DSSUBRECORD Name "EbcData" SqlType "1" Precision "30" Scale "0" Nullable "0" So, if you want to change the...

ray.wurlod wrote:Why do you want to know how U (one of our posters) can achieve it?

Or you can try

Or you can use Substring alone...

I dont think you can read only the columns you need from a file as you do in a table. If it is a dataset, then yes you can do it. I believe for a file, you need to read the entire record, and need to drop the unwanted columns.

To select/drop columns dynamically, you can use schema files.

No one is replying this post...

datisaq, I dont believe this is practically possible. You may not know how many rows you will get in your input

Or instead of setting it as user status, you can write it to a hashed file and look-up the value after your end-loop activity using UtilityLookUpHash.

Did you try it with Field? As Sultan suggested? If not try this

You cannot do it in a single job. Create your group xml in a job and in the next job you can look it up and create your final xml

Iconv(date,"D4") can also work for every date format, except, YYYY-MM-DD. Also, If Iconv doesnt recognize a incoming date, it will not return a zero, it will return NULL instead.

If it is a server Job:

What is your source and target stages? I believe we can do with some limitations.

1. Both your source and target should be files with same 'Line Terminators'
Or
2. Both your source and target should be db of same type. Oracle to oracle, etc.,