DSXchange

I guess that is a privileges problem (if you are sure that you have the correct port/location/collection).

Try this, open a telnet sesion, connect to AS400 server, log in with the user and password you are using in DS, run the command STRSQL and run the query you have in your job.

If this is on Windows plataform, ps -ef | grep phan kill -9 each phantom won't help. Antojj, you should talk with your DS administrator and if you have admin rights you should be able to close the sesion from Director/Cleanup Resources or Admin/commands/DS.TOOLS; but you need to be carfully because ...

Oh, I think that now I understand your requirement. I believe that there is no Conditional Lookup stage (you need parallel Lookup stage for that). If you only have two or three groups you can just create a derivation in a transformer stage like "If ID > Low then "group1" else "gr...

I believe that this error code 13 is a Permission Denied on UNIX.

Good luck

If you can create a job to load the hash file lookup with the columns ID_NUM<key> and GROUP, then in your job you should be able to join the ID_NUM and get the GROUP number.

sounds easy, good luck

I never saw this number, check the description here:

" in *.po files located under /branded_odbc/locale/en_US/LC_MESSAGES"

and let us know.

You need to run . ./dsenv from DSEngine directory, before run bind.

You need to run Bind command without this: "<>".

Something like $./bind20 PRISMDB2CONNECT

good luck!

Hi kame, To run UNLOCK command you need to do it from uvsh. I believe that if you are tring to unlock a job from the server, this way is much more simplest than DS.tools. You need to do something like this: telnet to DS server, load dsenv, then run ../DSEngine/bin/uvsh from your project and then LOG...

Where are the SPINTRIES, SPINSLEEP and other parameters adjusted? Which file on the server or the place on Administrator? These parameters are in the uvconfig (not .uvconfig) file, in DSEngine folder. After you change the uvconfig file, you need to run "uvregen" If you don't do that the c...

I think that this kind of codes are comming from your DB.

Is there any optimal setting for the array size. (I am using Oracle Stage and am connecting to 9i database) At first no. You need to test and find the optimal setting. Which performance has the job if you change the oracle stage to a seq file? How many rows do you have in the oracle table? how many...

I never saw this error message.. if you have the same problem in all the jobs with this ODBC connection, check the values in your .odbc.ini file... if is only one job may be is a bad SQL. Did you check the connection? try somethion like this... cd `cat /.dshome` . ./dsenv cd ../branded_odbc/demo ./d...

I received this error message when the job run out of Type30 files, you should check the PH file in order to find more detail.

To resolve this issue you can 'clear the status file' and recompile. But to prevent this kind of error you should contact Ascential support.

good luck

ridar wrote: So would like to know what are the best possible servers that we could use.

the easy answer to this question is, the one that you can pay...