DB2

Trigger Usage?
Hello, I have to create a trigger to accomplish the following: Before the insert into table A occurs, the trigger must check to see if the combination of two columns (from the insert statement) exist in another domain table. If the combination does not exist the trigger must insert a record into the domain ta... 29 Aug 2006 17:41

Default Date format using CAST in Stored Proc
We commonly use triggers to log changes to our main tables to historical log tables. In the trigger, we create a concatenated string of the old values by casting them as follows: CAST(O.MYDATE AS CHAR(30)) When directly updating date fields in the main table, the logged value gets saved in the format YYYY-M... 29 Aug 2006 10:40

SQL3525N on import/export in stored procedure
As importing/exporting data ist not directly supported for JDBC/SQLJ, we call a c-stored procedure which uses the administrative API for exporting/importing. Now with the newest DB2 8.1 Fixpack (#13), we get an error "SQL3525N CODEPAGE option is incompatible with the LOBSINFILE option during IMPORT". Using the w... 28 Aug 2006 05:17

Conversion Julian date to Gregorian date on DB2 load
Hello, I have Julian date in format YYDDD in the load file. A column in the table to be loaded has regular date format. I am using IBM load utility. How can I convert data? (In JCL before Load I can put some logic to modify Julian date field to YYYYDDD) Thank you very much. Mike ... 28 Aug 2006 05:17

How update one row with timestamp diferent
Thanks to answer topic previous!!!! I use this script to update one table MERGE INTO EIS.CLI_HISTORY TXN USING EIS.CLI_MAPING CLI ON TXN.CLIENTID = CLI.CLIENTID WHEN MATCHED AND CLI.STATUSID = 3 AND CLI.CLIENTID != CLI.MAPPEDCLIENTID AND CLI.CLIENTID = 24180 THEN UPDATE SET TXN.ISMERGED = 2, TIMEACTUAL ... 25 Aug 2006 19:49

"SQLWarning chain holds value that is not a SQLWarning"
Nobody has ever had this error in the history of the internets, except this IBM page talking about update 1.1 to something called "User Groupies" http://tinyurl.com/zlbyo On our JDBC connection we get a list of the currently reported warnings using: warning = connection.getWarnings(); NOTE: When i... 25 Aug 2006 21:24

connect to db2 server with odbc
Hi, i'm new to db2, so the answer on this question is maybe verry simple (or not)... i've installed db2 on a server, and now, I want to make a connection with odbc from a client (windows 2000). I installed the IBM DB2 odbc driver. To make a odbc connection i go to the 'odbc data source administrator', ... 22 Aug 2006 10:54

Transferring files from PC to AIX-DB2
Hi All, Can you please help me with a step by step procedure to transfer files from my PC to DB2-AIX and vice versa. I am new to both. Example transferring a sql file to run from PC to DB2 on AIX. PC-> OS windows DB2 on AIX platform. Thanks. ... 21 Aug 2006 04:56

SqlException Network IO
Hello, I use DB2 8.1 with fixpack 10, JDBC dirver type 4, with direct connection to host. I have no problems to get the timestamps from DB2SystemMonitor, when I execute the java program under Windows. With Linux I get the following message: com.ibm.db2.jcc.b.SqlException: Network IO time in microseconds is not a... 15 Aug 2006 12:36

Connecting to Stored Procedure from Crystal
I am trying to connect to a DB2 database using "iSeries Access ODBC Driver" from Crystal Reports. I am able to report on tables and queries but not stored procedures. I get the following error after I select the procedure and enter the parameter. Query Engine Error: '42000:[IBM][iSeries Access ODBC Driver] State... 15 Aug 2006 11:31