help!!! replacing nulls with a deafult value on a blob field

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

dineo.chokoe SSC Rookie Points: 46 More actions · Answer 1

sorry i did not make my self clear enough.

I use embeded sql in an RPG program and RPG can not handle blobs unless i sql.

I need to insert records from one table to another.

e.g, assuming C is a blob field with possible null.

insert into Table1 (a,b,c)

(select a,b,coalesce(c, ' ') from Table2)

Ken Simmons SSCertifiable Points: 7822 More actions · Answer 2

Try this.

insert into Table1 (a,b,c)

(select a,b,

CASE c WHEN NULL THEN ' ' ELSE c END

from Table2)

dineo.chokoe SSC Rookie Points: 46 More actions · Answer 3

sorry, i had some typo there. but rpg does not recgnise isnull.

check my code now.

C/Exec SQL

c+ insert into ibauthar

c+ (autable,aurfn1,autype,aucycle,auauthreq,auusrfn,audate,autxtran,

c+ aucethumb,ausign,auisasig,auusdid,auusfname,auusidno)

c+ (select

c+ autable,aurfn1,autype,aucycle,auauthreq,auusrfn,audate,autxtran,

c+ coalesce(aucethumb,' '), (case ausign

c+ when isnull then ' ' else ausign end),

c+ auisasig,auusdid,auusfname,auusidno

c+ from ibauthpf WHERE AUTABLE = 'KB' and AURFN1 = :KBRFN )

C/End-Exec

dineo.chokoe SSC Rookie Points: 46 More actions · Answer 4

it seems RPG does not recognise isnull or null at all. check my code.