MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Rexx DB2 insert dropping leading zeroes
Goto page Previous  1, 2
 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> TSO and ISPF
View previous topic :: View next topic  
Author Message
misi01
Advanced


Joined: 02 Dec 2002
Posts: 629
Topics: 176
Location: Stockholm, Sweden

PostPosted: Fri Jul 18, 2014 12:47 am    Post subject: Thanks for checking it out Roy Reply with quote

Your solution was one that was at the back of my head (I seem to have remembered reading about it somewhere).

What I don't really understand is why anyone would choose your working example over the second variation above that worked straight off the bat with "less" hassle ? If nothing else, to use the INSQLDA option, you then have to start looking up the required values for SQLTYPE etc etc

Before you say "because it's cheaper", I'll riposte with my usual comment to this at work. What costs more money, CPU cycles or us developers' time ?

Anyway, thanks again.
_________________
Michael
Back to top
View user's profile Send private message Send e-mail
misi01
Advanced


Joined: 02 Dec 2002
Posts: 629
Topics: 176
Location: Stockholm, Sweden

PostPosted: Sun Jul 20, 2014 3:05 am    Post subject: Roy. Reply with quote

Rereading my comment, I can see how it might be construed as being "impolite". My apologies for that. Basically, it seems to me that the second alternative is much easier than the first, so why would anyone even bother to look at the second one? You end up needing to jump through hoops doing stuff that isn't required in the first example. (Having said that, I can imagine that you probably (?) have to use the second alternative for VARCHAR columns, BLOBS etc, but other than that, why bother?)
_________________
Michael
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> TSO and ISPF All times are GMT - 5 Hours
Goto page Previous  1, 2
Page 2 of 2

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group