DSXchange

Yes, we could do that if ColB wasn't of lenght 800

Hi!
I have two columns in a table
ColA ColB
43459 30495
43463 28000300010800110001

I need the output to be
ColA ColB
43459 30495
43463 28000
43463 30001
43463 08001
43463 10001

In other words i have to split colA into multiple rows of size 5
Any help is appreciated
Thanks in advance.

Hi My DataStage job is creating huge logs and the job is aborting. Is there anyway I can reduce the job log? I don't know what kind of warning messages it is showing, because when I try to open the log in director , it tried to open the log but never actually does. I have to clear the log from the a...

[quote="ArndW"]Perhaps you have RCP enabled on the transform stage output, thus implicitly passing the column on. ...[/quote]

I used the Copy Stage and unchecked RCP. ANd it's working. Thanks for all ur help!

[quote="ray.wurlod"]A correctly-programmed Transformer stage (after the Sort stage) WILL work to drop a column. ...[/quote]
hmm. I used the transformer to just drop the column. It didnot have anything else in it. Do u think something needs to be added in the transformer?

I am going to try it. I tried, transformer, but that did not work.

I have a job that transforms data and assigns a serial number to it. At the end I want all the data to be sorted based on the serial number, but I dont want the see the serial number. DAtaStage works well if the serial number is pulled from the Sorter stage to the Output SF stage, but the data is no...

Yes, that seems like a reasonable requirement. What do you get out of DataStage when there ARE records in the file? How are you calculating this? Think about how any calculation could be performed ... I am not a premium member, so I don't know if you already provided the solution or not...sometimes...

To get the count, I am creating a dummy key column and counting it in the aggregator.
As a workaround I am having a row generator generate a zero value, and add it to the count from the aggregator(above).
So, even if nothing is in the file the value will be zero.

I have a situation where i count the records in a file and when the file is empty I need the count to be zero. But In DataStage it is not outputting anything.
Please advise.

I used Sorter , and then in the transformer I used this expression.
If keyChange=1 then Col1 : char(10): Col2 Else Col2

Got me the desired results. :-)

Hi I am trying to use pivot and am not getting the desired output, i searched the forum but none helped :cry: Here is my input Col1, Col2 -------------- a,1 a,2 a,3 a,4 b,1 b,5 b,6 And the output I want is Col ----- a 1 2 3 4 b 1 5 6 By using pivot I am getting a 1 a 2 a 3 a 4 b 1 b 5 b 6 Please hel...

My date is in YYYYMMDD format and when I use the function IsValid
for dates like 20100100 , an invalid date, the function says it is valid. Please advise.

Thanks!

Hi!
I was wondering if more than one job read a dataset at the same time? or will it be locked bcoz another job is reading it?

Thanks in advance.
A.