DSXchange

ArndW wrote:I agree :D.

Yes Arnd you were saying something

DSGuru2B, I have been working with DataStage for quite a few years now, and I know that the numbers reported are for rows output by OCI and NOT rows/sec. gateleys Well sometimes when the links are all cramped together and a person is frustrated in not able to solve a simple issue, things as such ha...

I think this was necessary. Its been happening a lot in the recent past.

hehe, your funny Craig. Still no word from the OP on whats going on

yea sorry, i knew i was off there, but was too lazy to open my job and look it up. Thanks Craig.
James huh...
I need to stop putting names in my quotes

Gateleys, you sure thats the number of records that you are seeing change and not the rows/sec.?

woooo, thats martian language . Ok sorry guys, just messing in the morning. Something seriously went wrong while converting it into a csv file. Do this, dont save it in csv, save it in a tab delimited format, you have that option for xls files. In the sequential file stage, specify 007 in the delimi...

Wow. An intelligent computer that can read a persons mood just by the motion of the eyebrows. O they will have to do better than that to even come close to RMM stage

sud wrote:
Simply using a filter(constraint) on the number of commas will serve the purpose.

Only if the number is known before hand

Actually i was. Thanks Ray. You really working on the RMM stage arent you

what is your sql? Need to take a look at that.
Also, when you write your own sql, press OK, get out of the stage, go back in and check wheather the changes you made were saved or not. I know the DB2 API gave me a lot of trouble once with this.

Group by the third column, do a sum on the salary by either using an aggregator stage or you do this even in the sql select. Let this go into a hashed file keyed on dept. You source will be the exact same source, do a lookup on your hashed file that contains aggregated data to get the nature of your...

Yes, a group change dance is required that can be accomplished via stage variables. THis has been discussed here a lot. Make the search engine your best friend

Maybe you are getting a comma in your data itself. Thats why the csv file is complaining for the extra column. Also, what exactly do you mean by meta data is not readable. How can you read the metadata from the file. Do you mean, while importing the metadata from the csv file your having problems, o...

No, from command line. I am not exactly sure of the syntax, you can look it up. But do it from outside datastage.