DSXchange

I'm curious now as well and will check one of the big PX repositories later to see what sort of entries are "R"{n}. Perhaps PX custom buildops? We'll see.

Ahh, then the problem makes sense. Does the XML get thrown into the /TMP directory or perhaps somewhere else where user permissions might be set differently?

Pavan - you probably ended up doing the right thing; but it's too late now to figure out the root causes of the problem(s) you had. Did you have a system crash while the machine was heavily loaded or other catastrophic failure that might have initially caused some of you problems? The DS Engine is q...

You can do a lookup directly to a DB2 table from a transform stage in DataStage.

The reason is the pad character that you have set, most likely in your enterprise stage, I belive the default is to pad with null (0x00) and you need to change that to space for your CHAR variables. I'm not at a system with documentation or DS right now so I cannot give you the exact settings to use...

How are you importing the tables and from what database. Do these tables that cause errors have datatypes that aren't found in the others?

Velagapudi_k:

1. This is because you are hijacking a thread; the original was on UNIX.
2. NEVER use "kill -9" unless you want trouble in UNIX
3. I use the LOGOUT command from TCL when working with Windows.

You stated that your server is on UNIX, so you will need to login to your UNIX system in order to logout processes, since they do not run on your client system.

attach to the subdirectory "bin" and try it again or put the bin directory into your COMMAND environment variable.

Posting the same problem twice has the effect that some people will take double as long to answer the question.

Perhaps you could answer the questions posed to you in the other thread and close off this one.

I have no idea how that could happen - but obviously it does. I'm glad you figured it out and posted the cause so that someone else might use the search mechanism to find the answer.

You really should get them to sponsor you on a training class before progressing any further, especially if you are going to build a prototype. Even if you know Server quite well, this task is like asking a Windows user to install and configure a UNIX implementation.

Note that Ray asked you to use a DOS shell and not from the TCL prompt. From the ">" prompt do a QUIT and then try your commands.

DRS, ODBC and the Oracle stages can all connect to an Oracle database.

The client permissions shouldn't play a role, as nothing is done on the PC client box - but it was probably the access permissions for the user with which you logged into the server with. Or do you mean that the compile error changes depending upon your local login and not with the userid/password t...