problem with Sql code -206



IBM's flagship relational database management system

Re: problem with Sql code -206

Postby Dashimir » Tue Mar 12, 2013 7:41 pm

I did this

select jasdk
asdfasd
asdfasdf
* asdfasdf
* number_thing
into jhaskdjh
kjsdhkfa
kjsdfkj
table-number-thing

Now it worked but why ? what do i do to make those columns go properly ?
Dashimir
 
Posts: 42
Joined: Wed Dec 26, 2012 7:27 pm
Has thanked: 2 times
Been thanked: 0 time

Re: Re: problem with Sql code -206

 

Re: problem with Sql code -206

Postby enrico-sorichetti » Tue Mar 12, 2013 7:54 pm

it worked because You obeyed the rule that an host variable should not have the same name as a column :geek:
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2797
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 148 times

Re: problem with Sql code -206

Postby BillyBoyo » Tue Mar 12, 2013 8:12 pm

Mostly people put a prefix on data-names, to indicate whether it is in WORKING-STORAGE or LINKAGE, for instance. If you had done that originally....
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Previous

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post