Recent content by Terris

The suggestion was to explain exactly what I am trying to do. I am looping through a control table that stores work table names. from these 'work' tables I am pulling the max date stored and updating another control table that keeps track of oldest date transfered from transactional to...

error message that has me stumped. Usually a PL/SQL user and not sure what to do. the SP is below the error message I'm getting is must declare @max_date, it is so I'm stumped Any help would be greatly appreciated. Thanks in advance!! SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO ALTER...

OK I'll try to explain a bit more, I'm beginning to think that Cognos and flat files don't work together. File is created by an etl process, resides on the same unix box that my DB2 database lives on. Need to pull the first 20 or so rows for review prior to sending the file off to a second...

I have a group of reports associated with a database through a catalog. I require information from a flat file. Thought I could use hotfile, renamed the file to end in .ims, file is not showing on the browse list. How can I make a flat file accessable to my catalog. This is a CSV delimited file...

Thanks for the idea, was able to use this concept to get what I wanted!!!!

Trying to work out if this is possible within cognos. Data source is a very simple summary table key description value 1 reject reason 1 nn 2 reject reason 2 nn 3 reject reason 3 nn *********************************************************** what...

That did it you guys ROCK, cannot tell you the grief this has caused me (not to mention the few extra grays) Thanks again!

'p' type items also have start and end date/times but it is calculated differently. the 'p' represents a parallel labor calculation so they clock in and out but the minutes are all jobs running divided by the number of jobs so I cannot just add the columns

but them amounts need to be combined into one record. There needs to be one record containine total time for each employee, each earning code. when you add the group by fp it works great except how do I then combine the two

swampboogie (love the name) I tried this format and got the following error Server: Msg 170, Level 15, State 1, Line 3 Line 3: Incorrect syntax near ')'. I am trying to sum up total working seconds for employees that are barcoding into our ERP system (evetually to create a text file to share...

the statement below does not sum in the else part of the case statement so my totals are off with only 'P' flabtypes being summed. Help!? SELECT FEMPNO, fcearncode, CASE WHEN Max(Ladetail.flabtype) = 'P' THEN sum(Ladetail.Fchrglab * 60) else sum(DateDiff(ss, Ladetail.fsdatetime...

I don't have alot of freedom with the database. I am writing custom reports off our ERP systems database developed by the software provider. I was however able to resolve this problem by doing a cast of a cast CAST( CAST( fieldname AS VARCHAR(17) ) AS FLOAT )

did not work Explicit conversion from data type text to float is not allowed.

two fields fmoldval and fmnewval table field defined as text. Would like to use them both in a mathmatical equation fmnewval - fmoldval actual data is stored in a decimal(9,5) Tried both cast as decimal (9,5) and cast as int and received the error message Explicit conversion from data type...

If I could only redesign, not an option I am reporting off an existing database that drives our ERP system. This is an audit table, the table name is stored in one field the table key in another. I am using this audit table to pull out changes to sales orders for a booking report). if the table...