CHAR for BIT DATA fld

[MKirkpatrick@xxxxxxxxxxxxxxxxx]

I have a column defined as CHAR FOR BIT DATA or CHAR(13) CCSID 65535 NOT 
NULL.  Why?  Because this is the way it is defined in another table from 
DB2 (Windows) that I am trying to duplicate/populate.  W/in my RPG pgm, 
the following stmt generates the correct data:  CREDGUID = 
x'20080618090909123456202020'; 

My problem is I need to use  a variable (TIMESTAMP + 3 chars) part of the 
value used to populate the CREDGUID column.  I have tried stringing 
together using the '+' char but when the data gets into the column it is 
truncated because the working variable is larger than the result 
(CREDGUID).  I also tried using the HEX SQL BIF without success.

Any ideas or suggestions would be greatly appreciated.  Thanks.





This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.  Unless you are the addressee (or authorized to receive for the addressee), you may not use, copy or disclose to anyone this email or any information contained in this email.  If you have received this email in error, please advise the sender by replying to this email, and delete this email immediately.  Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Western Dental Services, Inc.  Finally, the recipient should check this email and any attachments for the presence of viruses. Western Dental Services, Inc. accepts no liability for any damage caused by any virus transmitted by this email.