DSXchange

This function works as I expect StringToTime("05-08-04","%hh-%nn-%ss") but the data that I am seeing sometimes has only one digit for the hours, minutes or seconds, in which case the same function doesn't work. I wonder if I am missing something in the format string that ...

I've worked with Progress before - shouldn't be too difficult to extract the data into flat files and FTP the data over. I am very surprised that there is a mainframe implementation of Progress; and probably 90% of the denizens here have never even heard of Perkin-Elmer. That name belongs in the ann...

I agree that engineering (as well as the rest of the company) has treated shared containers badly for years. At least now they work are no longer black holes for coding work - it used to be that once stages passed the 'event horizon' of a shared container they were lost forever and could no longer b...

Ray,

I think that 768 is the current default, but looking at the quote from Ken it seems that 2048 is the maximum value. I haven't changed this value, so I don't know if the comments are correct. I still have a maximum size of 188 in memory from the old PI days.

Ken, I think that all of those who have worked with older versions of DataStage have this deep-seated and almost irrational dislike of containers. I shudder and cringe whenever I have to use them, even though they no longer bear the sign of the devil

Just to add to what Ken Bland already implied - don't raise this value unless you understand what it might entail. I think it far better to look at your key string and decide how you can compress it - most commonly by taking fields out of the key and moving them to the data portion. 768 is an awfull...

ggarze, there is no difference between the methodologies used in hashed files on Windows and UNIX. The minimum modulus is used only in type 30 hashed files and starts the file off with that modulus as opposed to the default value of 1. If your file contains enough records so that at the minimum modu...

In this case all the States are 2 digits and don't contain substrings of each other so the quick INDEX() will work well. If you were looking up a country list which might have ...USA,UK,UKMENISTAN... {doesn't exist, but I couldn't think of a better example} then it would make sense to change the com...

dprasanth,

yes, it does signify something, it is the output format. Please open up the BASIC programmer's guide on your PC and look up the chapter on conversion codes, specifically for the Date conversion. There are examples in there that should clear up some of your questions.

You need to do this in 2 steps, first convert the date portion into internal format telling it what the formatting is, then convert it to an output format in the new format. OCONV(ICONV(In.DateColumn[1,11],'D4MDY'),'D4DMY'[2,3,4]):In.DateColumn[12,99] This takes your text date and tells Datastage th...

The interprocess memory is set to 1024Kb (so 1Gb), you have 4 of them so the system will allocate 4Gb of virtual memory to "speed things up". Instead of being a good thing, this allocated memory needs to be swapped out to make room for user processes and associated memory. So it seems that by making...

Yes, you can use a procedure stage in that way. There is no limitation tat prevents you from creating a job sequence with a "lone" procedure stage that has no input or output links.

Could this be process memory and not disk usage? what are the ulimit values for this job?

Each instance of a multi-instance job must have a unique name. You are trying to concurrently run the same job with the same instance name.

Hello Rafidwh,

I used the search facility with the terms "upgrade 6 7" and got 579 matches. The answers are there already. There are a few aspects you need to check when doing this upgrade, but for the most part there should be no problems.