Join | Login | Why Join?   
SQL Server, Oracle, DB2, Sybase, MySQL Help - SSWUG.ORG HACKER SAFE certified sites prevent over 99.9% of hacker crime.
Search SSWUG:   
 
Access to 483 free guest articles, discussions and more, just create your free SSWUG User ID:
Email address:  
This will be your login ID - we'll email you your password - you'll even receive the newsletter, opt-out at any time.
Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

 

Date conversion when porting Sybase to DB2

Available for Members. This is an off-site link. Please review our Terms of Service (bottom of page) for additional information.  See Related Articles


 Article Abstract:

(Parminder Singh) When data is migrated from Sybase to DB2, problems arise from the MONEY, IMAGE, FLOAT and DATE data types. The format in which Sybase stores data is often different than DB2, which becomes a problem when manually porting from one to the other. For example, Sybase and DB2 DATE formats are entirely different. If a Sybase data column is loaded into DB2, it will give an error. Use the script below to overcome this problem.
(R, script)

 Read this article...
 Related Articles - For Members.
SQL Server 2000 vs Sybase ASE 12.5
Dealing with Foreign Currency : 'Conversion'
Mini-Tip #10 - Implicit vs. Explicit Conversion
Replication Agents
Replication Agent zaps for DB2 Versions 10.5
Replication Agent for DB2 - Troubleshooting TCP/IP Connectivity
RepAgent for DB2: Throughput Performance



Key (Please note):
(R) - registration may be required for access at the target site
($) - target site may require paid membership for access to this or other content

No Comments/Feedback Posted Yet. Post Your Comments/Feedback

Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

   



 

[ Register ] [ Webcasts ] [ Podcasts ] [ Newsletter Archive ] [ RSS/Feeds ]
[ About ] [ Advertise ] [ Contact ] [ Privacy ] [ Terms of Service ]
[ Link to SSWUG ] [ List Server Archives ] [ Recent Orig. Content ]
(c) 1997-2008, Bits on the Wire, Inc.  (0)

Some names and products covered by SSWUG are the registered trademarks of their respective owners.
DAA10354WWW004