DSXchange

Shawn Here is a way to do it in BASIC. You could change this into a DataStage job if you want. There is a header record in each dsx file. If you want to extract one job from the dsx then you need to add the header record to begin job and end job lines. If you can figure it out then use it. * -------...

My number one choice would be to have the feature built into DataStage designer to version objects using standard source control tools. Option #3 didnt seem to be that difficult to do, but like you I do not have the time or budget to do this. I may have to take a couple DSX files home and play with ...

Well... IMHO, of course. Unless you need more of the Check In / Check Out functionality in your versioning, then Ascentials VC works just fine. It is a heck of a lot easier than the old release-and-package methodology. It gives you access to the source in all of your projects and while it may not st...

All, We are trying to put together some kind of version control process with DataStage and was wonder what ways people are accomplishing this. I have come up with a couple of ideas myself but was wanting to see how others are accomplishing this. What I have is: 1) Use the Version Control package tha...

One way of dealing it with the problem is to split the inconing data to go to multiple files. For example a primary key ending with 0 to a file0 so on to ending woth 9 to a file called file9. Since we are in Datastage 5.x, we can run multiple instances of the same job where the job selects rows with...

Hi, We are using DataStage 4.2 on Unix. We have a simple job that has an OCI, a transformer, and a sequential stage. The OCI draws data from ORACLE tables and load the sequential file through the transformer. The job works fine so far until now when our tables produce more than 20-million records. T...

This is a topic for an orphaned message.

Hello All we have some job control basic code which starts up a multi instance job by adding invocation ids (.1 .2 etc) to the job name when doing a DSAttachJob. This all works fine. We then released the job and used the packager wizzard to deploy the job. Other jobs deployed with the packager work ...

Mark Usually DataStage puts @TM between fields. So the key will be: Key = field1 : @TM : field2 : @TM : field3 Thanks Kim. Kim Duke DsWebMon - Safely Control DataStage from the Web www.Duke-Consulting.com -----Original Message----- From: Mark Steen [mailto:mark.steen@bigfoot.com] Sent: Thursday, Jan...

the UtilityHashLookup function reads the record using

Read Rec From FileHandles(POS), HashKey Then

if the has file is created with multiple fields as the key, how should
hashkey be set?

thanks,
mark

This is a topic for an orphaned message.

(1) Index(string, character, 1) (2) Index(string, character, 2) = Index(string, character, 1) + 1 ----- Original Message ----- From: "Giovanni Boccia" Date: Wed, 29 Jan 2003 13:09:41 +0100 To: "datastage-users" Subject: Contain_String > Hi There, > > Ive got a really simple questions for you. > > 1-...

Thanks Kim/Ray, I did use the OConv function but was not sure the date was correct. I have since then changed the metadata from Date to Varchar(11) and I can now see the date. -----Original Message----- From: Kim Duke [mailto:Kim_G_Duke@Yahoo.com] Sent: Wednesday, January 29, 2003 12:27 AM To: datas...

Are you sure you want to put the user / password on the command line ? It will be visible to anyone on the Unix sever (e.g. ps -ef). The "-file" option might be better. I am on DS 4.2.1r8 on AIX. This "dsjob" problem looks like the return of old problem with this command. With DS 4.0, we had a simil...

Thanks guys. . -----Original Message----- From: wolfgang.huerter@gerling.de [mailto:wolfgang.huerter@gerling.de] Sent: 29 January 2003 12:19 To: datastage-users@oliver.com Subject: RE: DataStage / Unix problem. Hi Ian, it is general what Riccardo proposes: dsjob Command Syntax: dsjob [-file | [-serv...