#DateForumTypeThreadPost
901 Apr 2014 @ 06:19 PDTDatabaseReplyCALLing a dynamically created SP name.Don't know if it will be a success but this is what I would try: set SPNAME = 'Call sp_load'|| tablename ||';' CALL dbc.sysexecsql (:SPNAME);    
801 Apr 2014 @ 06:13 PDTDatabaseReplyDecimal and zeroes removalTRANS_CNT as  CAST(TRANS_CNT AS DECIMAL(18,2)  should be TRANS_CNT as  CAST(TRANS_CNT AS DECIMAL(18,0)  the 2 in your example defines the number of decimals what did you hav...
718 Mar 2014 @ 07:21 PDTDatabaseReplySequence number being resettedI use the following: CT ABC ( ID INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 100000000 NO CYCLE) ); It creates a unique value, but not a sequent...
618 Mar 2014 @ 12:36 PDTDatabaseReplyCalculating day number of the year for a dateslightly shorter calculation (in case you don't want to use the calendar-table): sel   date - cast(trim(extract(year from date)) || '/01/01' as date format 'YYYY/MM/D...
518 Mar 2014 @ 12:23 PDTDatabaseReplyStored Procedures and I/OAs promised the IO and CPU data I get the numbers from teraqueue.history   Stored Procedure IO: 7.253.180.525 CPU: 1.081.842   Logged SQL in a seperate script IO: 64.015.848...
417 Mar 2014 @ 08:11 PDTDatabaseReplyStored Procedures and I/Osorry for the delay dieter, I added mail-alerts on my thread and - as I didn't get any mails - tought no response had been posted yet. Hereby the (slightly cleaned-out) stored procedure /...
323 Jan 2014 @ 06:12 PSTDatabaseReplyStored Procedures and I/OI noticed that when one of the generated SQL's fails on exection no data at all is inserted in the target table. It's kind of "all or nothing" Can this have something to do with...
223 Jan 2014 @ 06:02 PSTDatabaseTopicStored Procedures and I/OHello I have a stored procedure in place that summarises data which can be found in other reports. How it works: I have a table in which is stored which data needs to be picked from which report...
123 Jan 2014 @ 02:48 PSTAnalyticsReplyTranspose rows to columnsCheeli In case you might have multiple entries per month in your table or values that can be greater or smaller than zero at the same time you can take Dieters code and replace the "min"...