| |
| |
| |
|
Page: 1 2 3 4
Comments:
<0> tried google groups ?
<1> I fire up the debugger, tell it to run my sp, and it sits there with a Debug prompt.
<1> not yet, I was gonna try here first
<1> I haven't found many people online using DB2 on an iSeries.
<0> maybe its wanting you to step through it
<0> or maybe theres a terminator you gotta type, or hell know, im just guessing
<1> yeah, I press F10 to step through and it exits
<2> Quant, care to elaborate, im a total sql server noob
<3> I have a dbfield that work as a counter. Can I increase the value by 1 in my insert into statement?
<4> Kulvis there is no need to try and replicate phrases from a book
<4> you don't have a db field, it would be a field in a table
<4> and call it a column
<3> k :)
<4> yes you can incriment a column by 1 in an insert statement
<4> or insert into
<4> column + 1
<4> you're inserting multiple rows i'm guessing
<4> using insert into, so a new table
<3> just INSERT INTO tblA (A, B) VALUES(A + 1, B) ?
<4> you will need some sort of function
<4> to keep incrimenting the value
<4> increment*
<3> everytime a user adds a new post it should +1
<3> so it is only one row each time
<4> why not use an auto incrementing column
<4> so the numbering is implicit
<4> answer goes here ___
<3> Cause I have to specify the field that should be increm
<3> ented
<4> the column changes?
<4> are you going to be running multiple clients inserting data at once
<3> no. I dont know how to explain, but I cant use auto incrementing
<4> ok
<4> state your rdbms
<3> access
<4> i don't deal with access' limited capabilities
<4> just try to get the highest value and add one to that
<4> that's your new incremented value
<4> i still don't see why you can't use an identity column
<5> i used to work at a place where we had a NextID table
<5> not sure why they weren't using auto increment
<5> insert blah (id) values (dbo.fnGetNextID('blah'))
<5> and that function would return the id to use, and increment the record in NextID table :(
<4> maybe they didn't want gaps tenfour
<5> probably
<5> i didn't work with that db though
<5> maybe they were char() ids or something too, so they could have employeeIDs of like 'E100' or something too
<4> retarded
<6> hrm ...
<7> zoul are you jewish?
<4> why do you ask such obscure questions
<1> Debugging DB2 stored procedures on an AS/400 is not meant for mere mortals.
<7> lol
<4> intimidated?
<7> cubert your name looks like pubert :)
<1> no, not intimidated, I just can't find good documentation
<4> tried checking the db/2 manual?
<1> yeah, I have that
<1> it tells me to refer to the ILE C compiler reference, which I read too
<1> and it refers me back to the DB2 book
<1> :P
<4> haha nice
<1> the screenshots in the ILE book don't match what comes up on my screen, and it's supposed to be for the same version of OS/400 as I'm running
<1> anyway... it's just been monumentally frustrating and I've spent nearly two days trying to figure this out
<8> sweet
Return to
#sql
or
Go to some related
logs:
smtp for embarq
bash >2
#worldcup
hortensia wep
#visualbasic
#visualbasic
nazi athem
#freebsd
American foreign donations
#beginner
|
|