DSXchange

What happened? The function as you posted will strip out all non-displayable characters and replace them (as well as the period) with stars.

I wish I did have suggestions. I think the compiler is licensed by number of concurrent users, and processes will wait for a free slot when that number is reached; so perhaps part of the long compile times might result from this bottleneck. But this is conjecture on my part and might be completely w...

Hexa, you are right, in the director you can't see the routine. But that is not what I suggested. In the Director you have an option to cleanup resources option that will let you list the locks, identify the process in question and then logout the job. Again, there are a lot of threads in this forum...

There are a number of threads in this forum regarding the unlocking of jobs from the Director and/or Administrator, the method is the same as that for unlocking a routine.

RobJ,

have you noticed a difference between jobs with and without transform stages? Oftentimes a job (even a very complex one) with no transform will compile quickly whilst a simple job with a transform might take a long time. If this is the case, it might have to do with the c++ compiler.

I think the ODBC drivers are for reading external sources into Progress, I don't know if there is a "push" type load method apart from creating sequential files in a format easily read into Progress using a program. I'd love to know if the ODBC is bi-directional for this, though.

The best thing is to have your deadlock daemon running; it will take care of things like this on a regular basis so you don't have to issue DataStage commands that might cause other problems if not done correctly. A routine is locked when edited in the Manager, if your session is terminated unexpect...

If your source is a sequential file of variable length records then you will not experience any gains by first writing it to a dataset and then processing it. The PX speed performance comes from it's ability to do things in parallel - but a sequential file read cannot be processed in parallel (unles...

Jamshid,

you cannot read a flat file using the dataset stage. Read it using the sequential file stage and write it to a dataset stage.

Hello Prakashs, The DataStage internal Julian date format is the number of days since Dec 31 1967, with dates before that being negative. So the results given by OCONV are dcomputed correctly for DS. In your case the Julian number is quite different, but if day 1721424 represents 0001-01-01 then log...

It would seem that this is a bug in DS, Ascential is working on a fix and/or workaround. I'll post whatever comes through from support here.

Hello jamshid, datasets in PX can be called by any filename and can be located anywhere on the system. They only contain schema and other information pointing to that actual data files and thus are small. I don't quite understand your problem or question, especially where you are getting an orchestr...

datastagehunter,

it is usually more useful to tell the truth about one's own location as well. What sort of documents are you looking for? Documentation on the product? DataStage v.7 downloads and license keys?

mITTA,

Dealing with binary data as well as nondisplayable characters in DataStage is easy. It is just a matter of what you want to do with those characters.

The Load functionality will buffer data - can you watch your temporary and scratch areas to see if they fill up during the big run?