DSXchange

I have problems with configuration of db2 server node. I read in documentation that if I want to use db2 enterprise stage to connect db2 server on a remote machine I need add an entry in PX config file. And I have a question about it: do I need to install PX engine on that machine where I have a db2...

I have defined an ODBC DSN and now I get the following errors: loaddb2..DB2_UDB_Load_4: ERROR occurred : loading table, SQLCODE -1024 loaddb2..DB2_UDB_Load_4: SQL1024C Połączenie z bazą danych nie istnieje. SQLSTATE=08003 (translation: A connection to database doesn't exist) loaddb2..DB2_UDB_Load_4:...

hi, I have a problem with jobs which are using a DB2 stage. It is the same in server and parallel job. These jobs are executing very slowly. For example simple job: seq file -> DB2 source data: two columns and one thousand records It finished after 7min !!! What can I do to speed up that jobs? Regar...

I install Express edition as server and client and it is working fine
Anyway thanks

But what is the name of DB2 client app? Run-time client? It is just a command line utility :/

Hi, I am trying to cofigure db2 plugin to connect to db2 database located not on the same machine as ds server. DS server is located on windows and db2 is also installed on windows machine, but it is not the same computer. I don't know what I need to install on DS server machine? DB2 connect? I want...

to be more precise:
$PX_HOME/include/apt_util

OK, I will check it. But isn't there a documentation about that?

Where can I find some info about APT_String type and other PX types used in Build OP stage? Some reference about methods which can I use on such type of data.
How to convert C++ string type to APT_String?
Thanks a lot.

Piotrek

1. What does RowProcCompareWithPreviousValue return after the comparison? Is it 1 if True and 0 when false? Routine description: The routine provides a persistent switch based upon the input data. If the supplied value compares with the previous value, 1 is returned, otherwise 0 is returned. This i...

I have just solved my problem. It was such a silly thing: just to trim a PRODUCT_ACCOUNT_NUMBER column
Thanks for your help

SQL query: select count(1) from HOLDER_UV where PRODUCT_ACCOUNT_NUMBER='196948' Output: SQL+ count ( 1 ) 0 1 records listed. End of output. Output of LIST DICT HOLDER_UV: TEST #1 ******* Arg1 = Test completed. Result = DICT HOLDER_UV 10:22:07 05-09-06 Page 1 Type & Field......... Field. Field......

OK.
I will post that after I came back from my summer holiday
Thanks once again.
I hope we will solve that problem finally.

Best regards,
Piotrek

Because you do not need quotes around a number. Why did you waste our time making this a lot more complicated than it should be. Cause it's not working. In this example there is a number, but in UV table PRODUCT_ACCOUNT_NUMBER column is a VARCHAR type. However thanks for taking your time. I will tr...

select count(*) from HOLDER_UV where PRODUCT_ACCOUNT_NUMBER='184306'; But this query return 0, which is not a valid result. When I use the query: select count(*) from HOLDER_UV where ID=1; then it's working fine. All result from executing the query I have posted a few posts before. Do you want to s...