Search results for query: *

I am using db2 version 7 and I need help calculating a date. I am selecting certain records with date fields from one table and then inserting them into another table after I calculate the fiscal year date field. The date from the first table is in this format: 01/22/1999, 01/20/2002...

I'm using db2 and I need to add another table join to the following sql statement. I'm confused about where I should add the INNER JOIN. Maybe this statement wasn't written efficiently but I'm stuck. I need to add another field into my select statement, bp13.dob_notify_date, and it's related...

I'm reading in a file and I have a six character date field coming in like this: 060299 so, it's month day year format. I know I need a y2k check so I can add 20 or 19 to my year field. But does anyone have a good function to format the rest of my string. I think db2 expects the date in this...

I need help writing a sql statement against some db2 tables. I think I can write this with a single sql statement but if i can't please let me know. There are four columns but the role column will be analyst and deputy. I'd like to get a single row made up of one unique agency. Here are the...

I'm trying to parse a comma delimited string with strtok - It's working fine but I have a couple of special cases: I'm reading from a file and one line of my 320-character string looks like this: JONES, SMITH, ABBEY, JOHNSON, LONG ISLAND, STATEN ISLAND, ... My program can handle most of these...

We have a word macro which generates a word document, opens it, and then "Save As" with a specified filename. The word document is launched from a hyperlink on a web page. The problem is if the user has this document open and it is minimized somewhere on the screen, the user cannot...

I have a C Program which writes out a fixed length file. The file needs to be read by a macro in Microsoft Access which expects the data in fixed starting and ending positions. However, when I try to import the file from Access, by: Get External Data... and then choose the file; the import only...

We are using Office 97 and have a Microsoft Word macro which creates a report and pulls in an Excel bar chart and pie chart. When the report is run with a resolution of 1024 X 768, the report looks great and is perfectly centered. The problem is that when it is run with a resolution of 800 X...

I'm using C Programming and am trying to write out a fixed length text file. The text file will be the result from a SELECT query against DB2 database tables. ----------------------------------------- EXEC SQL DECLARE C1 CURSOR FOR SELECT bp73.adds_id, bp73.priority, bp70.last_name...

I need to know the best way to insert data into a varchar field in a db2 table to optimize space and performance. Here's how the db2 field is defined: -------------------------------- struct { varchar purpose_desc[400]; varchar length; }purpose[400+1]; --------------------------------- Now...

I need to extract some data from db2 to a fixed length file so that it can be read by some Microsoft Access macros. I don't think I'll have to join two or more tables - it may be coming all from one table. (I'll post more info later, if this is the case.) I need to be able to set the starting...

I'm using office 97 and I have a word macro which inserts a text file from the server (along with several pie charts). I dynamically write a text file to the server and insert this text file into the word document. If the user launches the word document a second time, I want to delete the text...

I'm trying to run this load against DB2 from a command line: ---------------------------------- db2 "load from APPROPS2001.TXT of asc method L (22 25,1 20,54 58,63 65,59 61,76 76,62 62,84 103,164 183,424 435,460 471,82 82) messages msgs.txt insert into nysa.bp10t_appropriation (BUDGET_YR...

I'm trying to load a flat fixed length file into a structure and I'm getting some garbage in the data fields. Right now, I'm just trying to print to the screen the data that is in the file. Eventually, I wanted to then connect to a database and run queries so that I could loop thru and load this...

I'm using DB2 version 7 and I'm writing several scripts to be executed from the command line. These are simple inserts. Here's an example script: ------------------------------------------- db2 "INSERT INTO nysa.bp37t_temp_approp_distinct SELECT DISTINCT budget_yr, agency_code...

I'm using the load utility in DB2 and am trying to import a flat file with fixed length fields. The load goes fine however, I don't have a field on the file for the year that I am importing. Is there any way I can hard-code or specify the year that I want when I import the data into the table...

How can I concatenate a label with the value of a field that I'm returning from a SELECT statement in DB2? Here's my SELECT statement: The field with the label is: Unknown Agency + fieldname. ------------------------------------------ SELECT nysa.bp10t_appropriation.agency_code...

I have a query which works against SQL Server and I need to run it against DB2 version 7 from a C program. Here's the query from SQL Server: ------------------------------------------------ Insert into appropsdistinct select distinct acode, right(pcode,3),catcode, fundcode...

We have an intranet application with C/CGI scripting written against a DB2 database. On one of the HTML pages, we display a table with several columns of data in a grid. At the top of the table we pass a different WHERE clause to the server so that the columns can be sorted - ASC or DESC. The...

We're using C/CGI scripting against a DB2 database. We're working on a page where if the user clicks on a column header it will toggle and sort ASC/DESC. The problem is that we are sorting by a number of columns so that when we run the sort, each column has to have ASC or DESC following the...