DSXchange

Paul, that idea to copy the entire stage did it for me.
Thank you so much!
I am glad it was a simple solution and not tedious copy and paste.

That's a good idea Paul.
I will try to copy and paste the transformer stage with the links. That should work.
Thanks!

Thanks Craig for the suggestions. I was hoping there was an easier way. Cant create a shared container due to different metadata. I guess I will have just open up 2 sessions on 2 monitors and copy each one over manually.
Thanks!

Hello,

I created about 30 stage variables in a job that are being reused for multiple calculations. I need to recreate these in a similar job and I was wondering if there was a way to export and import these stage variables across jobs.

Thanks

Thanks Craig,
I did try that option, and it still outputs the fields with the single quotes around the values.

Hello, I am reading from Netezza and writing to a sequential file in csv format. I would like to have the dates output as mm/dd/yyyy and the decimals output as 000.00. I tried setting the format of the date in the format tab as '%mm/%dd/%yyyy'. The output is in fact mm/dd/yyyy but when the month and...

This is how I ended up resolving this issue based on Craig's input. (Thanks!) Created looping in transformer manually. I need to familiarize myself with the built-in functionality, so for now I went old school and created the looping using stage variables. Created a variable that incremented each ti...

We have a job that we migrated from 8.5 to 11.5 which was giving incorrect results. We narrowed this down to a transformer messing up the sort order after reading from a sort stage. We have tried changing the partition to "Same" but didnt work. The only way the transformer appears to maint...

Anyone?

So we have some data coming in where we need to do a vertical pivot and writing to a sequential file. But I would like to find out if I can make the file only as wide as the widest record, which means the array size for the pivot stage will need to be dynamic. I think I can get to what it should be ...

That's exactly what we are trying to replace, a view.

Looks like we will be reading from a file.
Thanks for your input.

So read from file, eh?
What I really meant was that it takes results from one query and outer joins to another and so on and so forth for 10 iterations to create groupings.
Still grappling with it, my first week at a new place.

Thanks!

Hello gurus, We have a sql from a view that loads a table that we would like to bring in to our Datastage environment to have more control over it. The SQL itself is over 97,000 characters. It appears the character limits for User Defined SQL, Before SQL, After SQL and parameter string are all 64,00...

I got it figured out after adding a NullToValue(Date,'') in a stage variable and then passing this to the PARALLEL transformer where I did this: IF ISVALIDDATE(StringToDate(DecimalToString(StringToDecimal(StageVar1) + 19000000, "suppress_zero"),"%yyyy%mm%dd")) THEN StringToDate(D...

Thanks for the responses. I have changed the IsValidDate to IsValid and passing the stage variable as date now. The Julian date is the date format on the iSeries (AS/400) which is our ERP system. The format you mention is in fact how it is stored, which is CenturyYYMMDD with 114 representing 2014. S...