DSXchange

Someone sent me (off line) a question about COBOL. Unfortunately I accidentally deleted it during routine cleanup of my mailbox. My apologies for the inconvenience, but could you please re-send it? Ray -- __________________________________________________________ Sign-up for your own FREE Personaliz...

Another technique is to use a delimited parameter; (i.e. 1906|1907) where the constraint either matches on one of the "array elements" or calls a routine which effectively does the same thing.

IBM (owners of the UniVerse RDBMS) regularly schedule classes. m Ascential Software (owners of DataStage) have a class called Programming with DataStage BASIC on the books, though not regularly scheduled it is available on demand. m Malcolm Bull Training & Consultancy Services has a series of self-t...

go to IBMs website for U2 training.... ull learn more there ----- Original Message ----- From: "Sharon Asmus" To: Sent: Friday, October 11, 2002 3:44 PM Subject: Universe BASIC > Hello, > > My company has just started to use DataStage. We are begining to find > out that to do any complex programming...

Hello, My company has just started to use DataStage. We are begining to find out that to do any complex programming (e.g, loops, dynamic parameter population, etc.) we have to write Universe BASIC code in the job control or in routines. None of the programmers within my group are very familiar with ...

A constraint is a Boolean evaluation. So, anything in a constraint evaluates to either TRUE or FALSE. Zero or NULL is FALSE, anything else is true. One solution you could try is doing something analogous to an SQL IN statement. If your store job parameter is a comma separated string of store numbers...

Hi Surendra, I know that it is possible only using command line. Moreover, export is a client utility so the syntax is the same both UNIX and NT DS server installation. You can find the command syntax and more info searching for "dsexport" in the "Manager Guide"! After that you only have to schedule...

Hi does any one know how to automate exporting datastage projects at regular intervals of time a. from director b. from command prompt The server is on Unix. Thanks, Surendra This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the pers...

Instead of building the possible store numbers as a constraint, why not build them each night into their own hashed file, with store number defined as the key? Then you could link your data against that hashed file, keeping only those records that found a match. >>> jash7@sears.com 10/11/02 10:38AM ...

Is is possible to put the entire constraint in a Job Parameter? I need to run a job that accepts a parameter of "store number". Example of my transformer constraint is: CustomerIn.store=1906 Or CustomerIn.store=1907 I need to be able to run the job against 1 or many stores. I have tried making this ...

"in the XML hierarchy that field is located. For example, a field "Name" would be defined as ContactNameFirstName)" Youll also need to use "@" or "#PCDATA" to dictate an attribute or element output. For instance, in the example above if the XML description was entered as an attribute, like this: Con...

Sorry, the attachment is too large and was not accepted. It was sent (and accepted?) on this list on 29/08 by Wolfgang, perhaps you can get it. Kasia Date: Fri, 11 Oct 2002 07:33:57 +0100 To: From: Kasia Lewicka Subject: Re: HashFile Creation-Speed Up Nuno, In attachment a document about (among othe...

ROFL Nice one Ray. I think that is about what I told him about 3 weeks ago. You must be getting bored? David -----Original Message----- From: Ray Wurlod [mailto:rayw@mindless.com] Sent: Friday, 11 October 2002 3:32 PM To: datastage-users@oliver.com Subject: Re: Multiple Invocation from dsjob I have ...

I have tested dsjob -run project jobname.invocationid and can report that it works ok. ----- Original Message ----- From: "Greg Smallhorn" Date: Sun, 22 Sep 2002 20:53:13 +1200 To: datastage-users@oliver.com Subject: Multiple Invocation from dsjob > Does anyone know whether theres an extra, undocume...

Actually, we do not support posting attachments to the list. Not only because of bandwidth for those subscribers who pay for every character downloaded, but also to prevent virii. If you have a document or file you think would be of interest to the list, please send it to me (no size limit) at moder...