DSXchange

Dear All, I have been solved this issue by creating logical file in AS400 then I can insert or update at a time. Thank you so much for all of you, Dear Ray & Craig, Thank you so much for your information. I will try to find the help file. May be it will be there. Thank you for your time, ICE I h...

Dear Ray, I have been solved this issue. I thought that the reason for I cannot insert/update to AS400 was due to char field but it wasn't. The actual reason was we can do only one type of transaction insert or update at a time. Hence it gave me error whenever I use insert/update statement. When I d...

Dear Ray,

Thank you so much for your information.


Thanks,

ray.wurlod wrote:For whatever database your driver is for, yes. For other sources you may get a different character. For example Microsoft Access returns a backquote into this field. Whatever Get SQLInfo returns is ...

Dear Ray, I get " character when I get SQL info. If so, it is default and I have no way to change it??? Thank u so much for your time, There's a button captioned "Get SQLInfo" on the stage properties page. It will retrieve the correct syntax from the database server or ODBC driver. If...

Dear Ray, Thank you so much for your advice. Yeah. I doble checked with IBM again and now I have decision to install DSJ server on 32-bit OS which will be located on different server from databases as they confirm again that their product is not compatible with 64-bit OS and I have to migrate our Da...

Dear All, I would like to change " to ' character when DSJ populate the insert/update statement?? Actually I changed ' in my ODBC stage and table definition from DS mgr but I still see " in my SQL instead of ' for char,varchar values. For example insert into table1 (aa,bb) values(1,"b...

Dear Chulett, Ok. I would like to ask myself. I have to check with Microsoft. Right? But here what I am confusing is how the microsoft will certify DSJ can install in their 64-bit OS??? Does their info be reliable??? I am so sorry for my poor knowledge :( Thank you for your time, If it is possible, ...

Dear Ray & Craig, Thank you so much for your information. I will try to find the help file. May be it will be there. Thank you for your time, ICE I have no idea where it is documented or even if it is supported by the DB2 stages but for Oracle it is documented in places like the Oraoci9.pdf file...

Dear Chulett, It is really a valuable information for me :-) Thank you so much for your time. If it is possible, please ask for me. I really want to make sure of it. Thank you again for your help :) ICE All I'm saying is that pretty much any 64bit O/S can still run 32bit applications, although the o...

Dear Chulett, Do you mean DSJ win server 32-bit application also can run on 64-bit??? Here is their repose. "DataStage8.0 or 8.1 for windows platform, they are only compatible with 32bit environment, not 64bit. However, you can use 8.0 or 8.1 on 64bit Unix, Linux and Solaris environment." ...

Dear All,

Today I received email from IBM support. They confirm that DSJ win server 8.x are 32-bit application and it does not support 64-bit OS at all


Thank u for ur time,
ICE

ArndW wrote:I went from 8.0x to 8.1 on AIX and we had to convert our buildops from the 32bit to the 64 compiler/linker ...

Different name???? No. I did not see it. What I understood was the DSJ server will internally change the code. May I know what I have to do next?? OR would u pls let me know where can I find those info??? I checked that info in DS Designer help file. When I got the compilation error, I just click he...

Dear Ray, Yes. It is correct. I must use that command to insert the rows to AS400 database using ODBC stage. Is there any other idea please??? Thank you so much for ur time, ICE Is "WITH NONE" valid ODBC syntax? (Note that I am not asking about the back end database here, I am asking about...

Dear All, I got below warning message n my DSJ job did not insert the rows to my AS400 table. I cannot find what is the problem here. Is there any idea please??? Untitled3..Transformer_40.To_POMDTL: DSD.BCIPut call to SQLExecute failed. SQL statement:INSERT INTO EDPAMD.POMDTLLD(PONUMB, POBO, INUMBR,...

Dear Ray, Yes. I have been checked on IBM website and I do not see for 64 bit window OS :( That's why I asked you again. I also called IBM and still waiting their response. Very slow response:( Thank you all, ICE I have just finished one site on AIX 6.1 (64-bit) and am embarking on another. I am not...