DSXchange

Hi, my friends. I'm working with DS 5.2, and a W2000 platform. I want to know what is the execution order of the stages in a server job. And also I want to know can I set it, or how can I control this order. Thanks in advance. Guillermo P. Barsky - gbarsky@osde.com.ar Gerencia de Sistemas - Desarrol...

Can someone tell me what the syntax on a filter stage is on PX? what will "Col_1 = 0 and Col2 not = 0" be represented as on a filter stage. Thanks _______________________________________________ datastage-users mailing list datastage-users@oliver.com http://www.oliver.com/mailman/listinfo/...

Kathy, You may want to just create symbolic links to each of the two files at Unix. Then your DataStage job can always refer to static names (substitute 'prev' and 'curr' for the actual date) without having to set the job parameters every time to match the dates. Remember that you can use the CRC32 ...

I am constructing a DataStage "Change Data Capture" program that compares the contents of today's daily sequential file with yesterday's file in order to specify which records have been added, deleted or changed. The source file names are in the general format "dailyfile_load_20040216...

Hi Bipul, this is not a DataStage bug itself. DataStage use the Unix schedulers at and crontab. This is not new to version 7. It was already in version 3. As a workaround we only choose, when using scheduler the "every" option for example every "thursday 6" and we then unschedule...

Hi Everyone, I need some help. When I schedule a job with 'Daily' or 'Every' option, the schedule appears on schedule menu (i.e the 'Blue' hour clock appears on the left side of the Job name), but if I select the 'Today' or 'Tomorrow' option, the schedule DOES NOT appear on the schedule menu (i.e th...

I'm prepared to bet you don't know the (physical) structure! :D However, I assume what you mean is that you know the record structure - that is, the metadata. You can, of course, read it with a Hashed File stage feeding a stream data link. In BASIC you open the hashed file, make a Select List of its...

The point is that there is no intrinsic function called ALNUM. This you can discover by checking on-line help, the DataStage BASIC manual, or signing up for Ascential's "Programming with DataStage BASIC" class. You could write your own ALNUM function. This is what the compiler is looking f...

Hi, Could you please give me more details about this tool and your company ? I need to import/export a single job through command line. __________________ Thanks & Regards, Rohan A. Kembhavi -----Original Message----- From: wolfgang.huerter@gerling.de [mailto:wolfgang.huerter@gerling.de] Sent: W...

Hi Guillermo, a Hashfile is relativly easy to read with DataStage. If you don't know the Metadata, you can create artificial ones: Key1,Key2.....Keyn and Field1, Field2,....Fieldm If you have to much it doesn't matter, if you have to less you loose information. With the edit-function you can see the...

Hi Rohan, we needed such a tool already in version 3.x for the export and import of single Jobs, though it was (and is still) not available from Ascential we wrote it ourself. We updated this tool for version 5.x and it works also for 6.x. (7x we did not test yet). Our company does sell this tool, w...

There is no ALNUM in the Universe BASIC Guide or in the server job developers guide. If it is a routine that has been added to your project then you should execute it as DSU.ALNUM. Call DSU.ALNUM(InputArg, ErrorCode) > Vincent McBurney | Senior Consultant | BearingPoint > Mobile: + 61 400 320 418 | ...

OK, I'm a little confused. I'm not familiar with AlNum - maybe it is a new function that we don't have in 5.2. If you have tried a few functions and some work, some don't, where are you getting this list of functions that you are trying. The error you are getting says that DataStage does not recogni...

No David, its ALNUM only. I have tried few string and date functions randomly, some of them seems to work properly, but others don't. David.Barham@Anglocoal.com.au wrote: I suspect you mean Num("hai") -----Original Message----- From: Rocky Maviya [mailto:mail2rock2003@yahoo.com] Sent: Wedn...

I suspect you mean Num("hai") -----Original Message----- From: Rocky Maviya [mailto:mail2rock2003@yahoo.com] Sent: Wednesday, 25 February 2004 9:49 AM To: DataStage Users Discussion List Subject: Using functions Hi, When I tried using standard string functions in DS, some of them seems to ...