network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 9 months |
| seen | Apr 11 at 22:27 | |
| stats | profile views | 7 |
Just another hacker specializing in Java, Perl, and of course JavaScript in the world of the Web Application...
|
Jun 11 |
awarded | Notable Question |
|
Dec 23 |
awarded | Popular Question |
|
Dec 12 |
comment |
Do I need to RUNSTATS after a REORG in DB2? Good information, and glad you posted, but sadly, no. I am running this on a Windows 2003 Dell, and soon to be migrated to a custom built CentOS server. |
|
Dec 12 |
accepted | Do I need to RUNSTATS after a REORG in DB2? |
|
Dec 11 |
asked | Do I need to RUNSTATS after a REORG in DB2? |
|
Nov 5 |
comment |
How do i subtract a number of days from a prepared statement parameter in db2? @ypercube, it does |
|
Nov 3 |
awarded | Commentator |
|
Nov 3 |
comment |
How do i subtract a number of days from a prepared statement parameter in db2? Tried this, seems that the type from the CROSS JOIN is not set because i get this error: An expression with a datetime value or a labeled duration is not valid.. SQLCODE=-182, SQLSTATE=42816, DRIVER=3.63.108 |
|
Nov 3 |
revised |
How do i subtract a number of days from a prepared statement parameter in db2? More specifics about my environment. |
|
Nov 3 |
comment |
How do i subtract a number of days from a prepared statement parameter in db2? @dezso, thanks, i missed that, editing the question to state I am using OLEDB |
|
Nov 3 |
comment |
How do i subtract a number of days from a prepared statement parameter in db2? @JackDouglas, That was my initial thought. DB2 has SYSIBM.SYSDUMMY1 for that purpose, but not sure how to join with the already joined tables... perhaps FULL OUTER JOIN? Would that effect performance or anything? Could you show the query you suggest? |
|
Nov 3 |
comment |
How do i subtract a number of days from a prepared statement parameter in db2? @Jack Douglas, I am invoking the statement inside of IBM Data Studio (the official administration client). I am explicitly setting the type of the parameters to TIMESTAMP when i run (press F5) the command. |
|
Nov 3 |
comment |
How do i subtract a number of days from a prepared statement parameter in db2? Yeah, i wish. Not available with OLEDB: The OLE DB .NET Provider does not support named parameters for passing parameters to an SQL statement or a stored procedure called by an OleDbCommand when CommandType is set to Text. In this case, the question mark (?) placeholder must be used |
|
Nov 3 |
comment |
How do i subtract a number of days from a prepared statement parameter in db2? I usually do stuff like that, but in this case, the different weeks don't have meaning outside of the context of this query. Ideally, i would like to do something to calculate the different week ranges 1 time on the database end and reuse, but, short of pl/sql, i cant figure out a way. |
|
Nov 3 |
comment |
How do i subtract a number of days from a prepared statement parameter in db2? Wow, -1 and no comment. Would be helpful if you could tell me why my question is stupid. I would be happy to request delete if I am not making any sense. |
|
Nov 3 |
asked | How do i subtract a number of days from a prepared statement parameter in db2? |
|
Sep 17 |
awarded | Teacher |
|
Sep 17 |
comment |
Memory limitations on db2 express-c version 10.1 seems stuck at 2 gig, why? @AngerClown, would you mind expanding on that? Which setting in particular are you talking about? |
|
Sep 16 |
answered | Memory limitations on db2 express-c version 10.1 seems stuck at 2 gig, why? |
|
Sep 16 |
asked | Memory limitations on db2 express-c version 10.1 seems stuck at 2 gig, why? |
