DSXchange

could it be a read-only job?

Hello Ridar, that is an impossible question to answer directly; in the car world that would be the equivalent of asking "I would like to buy a car, any recommendations?". Here are a couple of questions whose answers will influence the decision: - What flavor of UNIX and/or hardware is already in-hou...

LogicDude,

uncluttering the desktop is the only effect that I can think of.

The c++ compiler counts concurrent accesses, and it seems that you have hit the limit. Do simpler jobs compile? If so, then the compiler limit is probably teh cause.

Multiple write links to a sequential stage are possible, but only if each link has a different sequential file to write to.

Multiple write links to a table are possible.

Reddyds,

there are no urgent problems on this forum, urgent issues need to go to your support provider.

yes, you can have more than one instance installed on a given box. The documentation explains how to do this; since this is a pressing problem you have a quick solution.

hemant,

I don't think that the error message alone is sufficient to diagnose the problem in this case. If you were to take out the lookup does the error go away? Are you using your own SQL or generated SQL? Does the SQL execute if you try to enter it manually in sqlplus or whatever tool you use?

Have you looked at your APT_CONFIG file?

Instead of a direct response, let me ask a question that has a direct bearing: what is the partitioning method of a sequential output file?

The DataStage hashed files have not changed, so there ought not be issues there. It used to be possible to change DataStage job parameter values within the job and this was occasionally taken advantage of; this will no longer work at version 7.

The XTD function turns it into a displayable value, but then Ray turns that value into it's 1-byte binary representation using the CHAR() function. So it does exactly what you initially wanted. Now you want to take a text number and transform it into a 16 bit representation. If you have a number tha...

Ray - that's an awesome idea, I hadn't thought of that! That will save time on inode searches (since files not in the VOC won't be found it will still have to look). Doing a "find" on this large system takes about 45 minutes; but goes go faster when limited to just one device. I am writing a program...

Greetings to Arizona, gradkarthik (my home). DataStage server doesn't perform an actual data conversion by just specifying the new column width in a transform, you need to do an explicit conversion on this column to convert it. I am not at a DS system right now, but I would use the FMT(In.Column,'R2...

Phil, the hashed file stage does work as you described. Regarding the creation of an empty hashed file in this job, why don't you just click on the attributes in the hashed file stage to have it create the file for you? Although a before-job routine or the job control tab could be used to execute th...

I know there must be a better solution, but I can't find it. I have a device and an inode (coming from the LIST.READU command) and I want to find the actual file associated with that; the only method I know is to use "find -inum {inode number}" but that actually has to search and can take minutes or...