DSXchange

as Kim requested, I would be interested to see your timings both ways, but like the others would assume that using the hashed file would be the best performing. This may not fit into your current case with the 20 row table, but one thing to consider is when your reference table is possibly changing ...

Since Guillermo had compile errors, but I didn't get compile errors when doing a copy/past of the code, I'm wondering if maybe there is a compliancy issue with NLS? Guillermo, can you confirm is your server has NLS turned on? Can some others with and without NLS copy/paste the code and see if they g...

Also, is this defined as a transform function, before/after subroutine, or custom uniVerse function?

I pasted the code into a transform function and created the arguments and it compiles with no errors (DataStage 7.1)

What are your routines arguments? xDrive, xPath, xFile, etc.... ?

I just want to make sure that is a correct assumption.

this might be a shot in the dark. I'm not sure (and I think we are all wondering) why you have this need in the first place to truncate a project, but depending on what you need to do I'm curious if something like this would work for you: Could you possibly create many projects in advance (manually)...

Actually, I think I knew Microsoft Visual Basic was the leader :lol: I guess you answered correctly, but I was wondering who is the leader in the non-visual Basic (as well as wondering what is the runner up in the visual category to Microsoft VB) . But I also didn't know about the free download from...

Actually Fitzgerald and Long have some good information http://www.fitzlong.com on their site. These two must love hashed files more than anyone else. Its focused more at static hashed files and users of UniVerse, put click the support button and then technical papers link for some pretty intense do...

ah. found dsbuildinfo on the UNIX install. Under the DSEngine directory, except it is listed as a hidden file and is named .dsbuildinfo

I want to create a dynamic hashed file, probably with SEQ.NUM algorithm. I have four columns for the key: GEO_COUNTRY, GEO_STATE, GEO_COUNTY, GEO_CITY. GEO_STATE is character based, the other 3 are integers. The only values for GEO_COUNTRY are 1 and 2. Obviously you can guess the likely proportions ...

this is an interesting thread...thanks for the info. I do, however, need to ask when will it stop? What's next? Is it possible to make wireless alarm clocks that can receive a code via SMS that would set the alarm clock off and wake us up in the middle of the night so we can go back into work? :roll...

I thought for some Friday night fun I might play around with another dialect of BASIC than UniVerse or DataStage BASIC and see what I could accomplish and if it would enhance my programming thought process when coding in DataStage BASIC. This site lists around 75 dialects of BASIC. I think much of i...

Wolfgang/Ray...thanks for the replies. I do like ProfileStage and AuditStage, and AuditStage may be a good 'quick & easy' fit for the process on analyzing spreadsheets. Hopefully if Access is being used then fewer problems exist than in Excel. The problem as a consultant I face is that client of...

FYI, if you don't like the Batch:: or it doesn't fit your naming conventions you can still have this same Job Control code in a server job, but the canvas won't have any stages. And putting an annotation on the canvas denoting the job has job control in it is a helpful best practice. The key differe...

chulett wrote:

ray.wurlod wrote:If you want a detailed reply, you might be better off posting on ADN.

And this was...? Why go there when you can get the Full Wurlod right here?

In the tradition of having a 'Hello World' tutorial program, can we have a 'Hello Wurlod" program?

Thanks for your help


for some reason I always want to use ls thinking there should be a flag for that command to search through directories.