DSXchange

Include the same COMMON declaration(s) in both the before-stage routine and in the transform function that uses it. For example: COMMON /MyVars/MyVar1, MyVar2, MyVar3 Values set in variables MyVar1, MyVar2, MyVar3 (in this example) in the before-stage subroutine will be accessible in transform funct...

Hi Andy, Yes, you could build a Plugin using the DataStage API to read and write to Tibco. But since a Tibco plugin is currently being planned / developed by Ascential, I would speak to your local Ascential Sales office first to see if it fits within your timelines. Cheers Stewart -----Original Mess...

Hi Anju, As Craig says, it reasonable straight forwards to write some Job Control to split your input file into new files as required. Weve done it a few times. For a more elegant DataStage based solution, you could try using the Folder stage from the XML pack. You will need to sort the input file b...

Im pretty sure this was just recently discussed... try searching the archives at m -craig "Jennifer Weise" 08/23/2002 01:38 PM Please respond to datastage-users To: cc: Subject: Range of Numbers I need to be able to read a hash file containing two data elements representing a range of numbers (e.g.,...

I dont believe there is a way to do this in a traditional DataStage job. As far as I know, youll have to write a batch type program in DataStage BASIC to accomplish this. Shouldnt be too bad... check for key change, close old output, generate new filename and open, write until change again, special ...

I need to set a variable in a before-stage routine and reference it in the Transformer Stage. How do I do this?

Thanks,
Chris Roberts

I need to be able to read a hash file containing two data elements representing a range of numbers (e.g., 17000-18000,) with another file to see if a value in the other file exists in those ranges. How do I key the two files together and how do I read the 2 data elements as a range to determine if t...

We have a need to split a file into multiple files based on a certain key field in that file. For example, for the following file: Row No Key ------ ---- 1 XXX 2 XXX 3 XXX 4 YYY 5 YYY 6 ZZZ ... In this case, this file should be split into 3 files - first 3 records go to one file, next two to a secon...

Thanks Glenn!

Scott

>>> glenn.herbert@ascentialsoftware.com 08/23/2002 10:12:31 AM >>>
Well, the documentation says that is possible. However, the implementation
of the BASIC lexer has never handled this, so the answer is no.

Thanks Len, Wed actually twigged that one last night, however now weve got another issue with the reader stage - perhaps you could give us some clues here. It would seem that the reader stage wants the XML data to be rigidly in the order that is specified in the colum descriptions - if its not then ...

Well, the documentation says that is possible. However, the implementation of the BASIC lexer has never handled this, so the answer is no. At 09:34 AM 8/23/02, you wrote: >Hi All, > >Is there a way in DataStage Basic to continue a line of code? > >Example: > >If LookFor = "aaaaaaaaaaaaaaaaaaaaaaaaa"...

Its the difference between writing /element1/element2 and /element1/element2/#PCDATA in the derivation (or description) field of a column. Given XML that looks like: abcd then the first derivation gives you the whole of element2, i.e.: abcd and the second gives you just its data content, i.e: abcd A...

When you limit a batch job to return 100 rows, does that limit filter dowen to the rest of the jobs in the batch?

Denzil

Hi All, Is there a way in DataStage Basic to continue a line of code? Example: If LookFor = "aaaaaaaaaaaaaaaaaaaaaaaaa" Or LookFor = "bbbbbbbbbbbbbbbbbbbbbbbbb" Then * Do Stuff End In Visual Basic I would use an underscore to continue. Is there a way to this in DataStage Basic? Thanks, Scott

Morning All, Does anyone have experience of taking data from Tibco with Datastage ??? Can Datastage take data from a source via an API ??? Thanks, Andy. ________________________________________________________________________ This e-mail message (including any attachment) is intended only for the pe...