Hello Gurus, Question..
I tried to restore a backup AIX's DB2 db in Linux's DB2 same version and fixpack... but get error saying...
SQL2570N A database cannot be restore on a platform that does not match the platform on which the backup image was created
Is there a better or alternate ways to do this??
graju80
Last Activity: Jul 23 '07, 09:13 PM
Joined: May 8 '07
Location:
-
Restore between Platforms
-
OK whew!!..that worked...I swear to god Quest put those quotes there...Thanks Herb! -
SQL0206N during create trigger...
Hey Gurus..I am trying to figures out where my syntax is incorrect in the following SQL to to create an after insert trigger... I am getting
SQL0206N "INSERTROW.MF_U SERID" is not valid in the context where it is used. LINE NUMBER=1. SQLSTATE=42703
CREATE TRIGGER "O000634"."test _insert"
AFTER
INSERT
ON "O000634"."TMAX 300_USER"
REFERENCING... -
DB2 Datatype Determination in DB2...
I am kind of new to Db2...
Question: What are the rules that DB2 uses to determine the right datatype for a particular column for on-the-fly SQL generation?
For example...
The following code snippet:
(sum(AMT3) - sum(AMT2))/sum(AMT2) as DIFFPER is part of a bigger SQL Statement..
AMT3 and AMT2 are part of a table. DIFFPER is created on... -
Data type determination in DB2..
Question: What are the rules that DB2 uses to determine the right datatype for a particular column for on-the-fly SQL generation?
For example...
The following code snippet:
(sum(AMT3) - sum(AMT2))/sum(AMT2) as DIFFPER is part of a bigger SQL Statement..
AMT3 and AMT2 are part of a table. DIFFPER is created on the fly...
So assuming AMT3...
No activity results to display
Leave a comment: