DSXchange

kduke wrote:It looks as if there is one too many END statements.

yes I fixed them.. when i was starting to indent I realized that.. thx kduke

I modified the hashLookUp program and its giving compile error. This is my 1st BASIC program ever tried to compile. it gives 'End of file unexpected, Was expecting : Array Name, Variable Name' can somebody tell me what the problem is.. thanks *********************************************************...

... or a recursive routine using BCI functions. It's Windows, so there are not ODBC licensing issues. It can be done, I've done it: a scheduler in which all the dependencies were in an Oracle table, nested up to seven levels deep (but potentially more). what is a BCI function.. can you give me an e...

Why not sort the child records by parent, then process the child records and reference the parent record for each child, use stage variables to accumulate intermediate results, and send the final result out to an aggregator stage using the LAST derivation for all columns except the key columns? You...

ray.wurlod wrote:Welcome aboard. :D

Yes, it can be written in DataStage BASIC.

how do I write though .. I am a beginner .. can you guide me pl

My project involves reading a record which is parent and each parent record has a set of children records. its basically hierarchy. when I read each children, I need to check previoussly read children records and check for certain rules, and finally process the record. there will be a mximum of 10 c...