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...

thanks, I tried the first one and that worked great! John

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...

MarcLodge, Thanks for the response - I figured out how to link the table to itself (by alias) and it's working. Thanks John

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...

Thanks for the posts. I finally fixed the problem. Had to trim the white space from both ends of the tokens. Here's the function I ended up using: ------------------------------ char* strtrim(char* str) { int i = 0; int j; while (str[i]!= '\0' && str[i] == ' ') i = i + 1; j = i; while...

marsd, Yes, I'm still having a problem parsing thru my string. Since my data was entered as: comma then space, it's a problem. For example, I have JONES, SMITH, ALLEN, PARSON, ... If you could post that string splitting function, I would appreciate it. Thanks John

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...

Thanks Rob, Right now, we do pop up a message box if the document is already open. I thought there might be a way thru code in which we could compare file names and then... If that document is open, we could close it and then re-open it. Here's the current macro code...

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...

DucatiST2, Thanks for the help. That fixed the problem. John

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...

jnelms, I answered my own question - thanks for the help. Do you know if there is any way I can strip out the single quotes that get inserted around each data value? ----------------------------------------------- Here's the statement I used: db2 "EXPORT TO test1.txt OF DEL MODIFIED BY...

jnelms, Thanks for the response. I was just about to ask that question about alignment. I can handle all the character data if I use substr(dob_field,2,3) but I have a problem with fields defined as sqlint32 and sqlint64. By your code above, are you saying that I can cast these integer types...

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...

Rob, Thanks for the response. Yes, when I check in windows explorer, the new file is there. And, I do explicitly close the file. Is there anything else you can think of as to why my file is not updating? Thanks John