DSXchange

try use

select Computer, SoftwareProduct, DataStore, DataSchema from MetaStage_Loc_Info with UR

what's your DS version? I met this issue in 8.0.1 before.

and If you wrote sql like this

SELECT ...
FROM ...
WHERE DER_AUTH_CD IN ( '#pLocalAuths#' )

passing a value such as 001','002','003','004 should work

and I remember this issue fixed in a later patch.

as far as I know, TD fastload requires an empty target table.

the best way to acsess data on iseries is to use ODBC.

if you want to read 10000 rows, and you are reading by 2 nodes, you should put rownum <= 5000 in your sql. you are absolutely in the right direction. you are spliting the rows while enabling partition read. to read the database in parallel increase the performance much. if you are loading the data r...

each node will generate a sql and send it to oracle to execute, datastage will append a "mod(your_column, num_of_node) = node_num" condition in your where clause in this case. so each node will return 1000 rows. that's the right behavior.

I have no idea on your issue with switch stage, but I think you could use a filter stage or transform stage instead. why not have a try.

check if your logging agent is running. I got the same issue, but i found the logging agent was down at last.

Hi Brajesh,

I now can confirm that AS400/DB2 is not support by db2 connector at the moment, so you should go with odbc or db2 api stage.

Hi,

If you use user defined sql in the stage, you should add an alias name behind each column in the select list, and the alias name should be mapped to the column name defined in the table metadata.

so the sql should look like this

have you done this step?

On the primary computer, create the remsh file in the /Server/PXEngine/etc/ directory with the following content.
#!/bin/sh
exec /usr/bin/ssh "$@"

personally, I think it's not a bad idea to deploy DS on windows server, it's easy to connect to data source with odbc, and have quick access to sql server. Some stages are running better performance than linux, and of course some not. But it seems the DS will be more stable on unix/linux.

Hi,

ServerName=<Datastage_Server_IP_address>

I think it's incorrect to use server ip here. you need use oracle service name instead, which is TEST_DB in this case.

firstly you should figure out what the character encoding (e.g. UTF8, GBK) is used with your source file.then set the correct NLS to your stage. NLS ISO 8859 is obviously a wrong codeset for Chinese.

meet_deb85 wrote:This is the entry in my /etc/hosts file : -

127.0.0.1 kasitmisdb1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
172.21.13.53 kasitmisdb1
172.21.13.254 kasitmisdb3

try removing "kasitmisdb1" from the first line.