• Qmf for Windows 8.1 fp18 – date datatype from db2 z/os 8 format error in excel 2003

    When I import a DB2 z/OS query resultĀ  containing date or date(timestamp) columns from QMF for WINDOWS in EXCEL 2003 using the Add-in the cells cannot be formatted. In the same column the date are displayed sometimes as dd/mm/yyyy, sometimes as nnnnn or in the previously defined format (example...

    Erredi5 pointsBadges:
  • Create DB2 table relations

    There is a requirement to have a subset of data available in DB2 tables in production to a test environment. There is no relationship defined in DB2 (so info available in catalog relationship tables). Now we need to find the relationship between the tables using some automation process. So we might...

    Toramky5 pointsBadges:
  • SQL / DB2 Optimization (timing out)

    I put together a simple VB program to run SQL commands on any of our 4 I-series machines to return a simple grid view. I have run across a strange problem and was told it may have to do with optimization. For example if I run the following SQL ( I just want a count of parts (pm) that have not been...

    ToddN20006,360 pointsBadges:
  • Having issues connecting DB2 with .NET

    I'm trying to connect to a DB2 database (an iSeries version) using .NET by referencing a .DLL and not installing software on my server. I currently have IBM.Data.DB2.iSeries.dll installed as part of iSeries access for Windows. Is there an easy way to connect from .NET to DB2 by referencing a .DLL...

    ITKE54,720 pointsBadges:
  • Is the new WRKDBF out yet?

    Anyone heard if the efforts to recreate a WRKDBF utility have borne fruit yet? Once again I find myself needing a general purpose file view utility, and hover on the brink of writing something, for I saw somewhere that a new one was being put together.

    Yorkshireman5,520 pointsBadges:
  • Need some help with queries in DB2

    Members on our team have a massive database that's housed in DB2 for i server that they are accessing through SQL Explorer. But the tables aren't very well documented and they're trying to do a few things with it.Search the entire database that look for tables with a column called "Remarks"Search...

    ITKE54,720 pointsBadges:
  • I’m having trouble with a simple query in DB2 for AS/400

    I know I'm an amateur when it comes to AS/400. I have this "easy" query but I still can't do it. Here's what I have:A B C 1 1100 5 1 1100 5 1 500 1 2 1200 4 2 1200 4 2 600 1 3 1300 3 3 1300 3 3 700 1And this is how I want it returned:A B C 1 1100 10 2 1200 8 3 1300 6I tried this but it's only...

    ITKE54,720 pointsBadges:
  • how to set gridview column width to auto

    I put together a simple vb program, or so I thought. I am accessing DB2 tables and trying to pull the data in using a DB2 reader. What I'd like is to have the columns be set to width=auto. The number of columns depends on the DB2 table. I'm getting an error "Index was out of range. Must be...

    ToddN20006,360 pointsBadges:
  • iSeries: Text fields from different records in same file

    We have some data (in a file of course) on iSeries using DB2. Here's the file structure:Item Textline Text 12755 1 this item 12755 2 is no longer 12755 3 for sale abc123 1 please use abc123 2 another code xyz987 1 obsoleteThis is the result that we're trying to get: Item Text 12755 this item is no...

    ITKE54,720 pointsBadges:
  • What’s wrong with my following code for connection to a DB2 database?

    I'm trying to connect to a DB2 database with PHP. I have a code but it's not really doing anything for me. It's not returning an error message but just breaks JavaScript later in the page. Here's the code:include(TEMPLATEPATH.'/inc/library/adodb_lite/adodb.inc.php'); $DBName = 'DBNAME'; $Host =...

    ITKE54,720 pointsBadges:
  • DB2/iSeries clean up

    I'm trying to find and clean up line breaks, carriage returns, tabs and "SUB"-characters in a set of 400k string records but I'm having a ton of trouble with my DB2 environment.After doing some searching, and I thought replacing with the "REPLACE()" and "CHR()" functions could work, but it's not...

    ITKE54,720 pointsBadges:
  • Having difficultly making my DB2 queries case sensitive

    I'm been having a lot of problems making my DB2 (AS/400) queries case sensitive. Here's an example of what I'm trying to do: SELECT * FROM NameTable WHERE LastName = 'smith' That returns zero results but this returns 1000's or results: SELECT * FROM NameTable WHERE LastName = 'Smith' Does anyone...

    ITKE54,720 pointsBadges:
  • Looking to add a column to DB2/400 table

    I'm a beginner with AS/400 and I'm wondering if there's an SQL command on AS/400 to add a column to a table in a specific ordinal position (or moving an existing column to a different position)? Pointing me in the right direction would be great. Thanks!

    ITKE54,720 pointsBadges:
  • Can I select the identity value from an insert statement?

    Our company is using iSeries for DB2/AS400 and we're hoping someone can help us with this simple question. Would there be a way to return the identity value from an insert statement without using two lines of SQL? We're currently being forced to use inline SQL in C# to perform an insert. Basically,...

    ITKE54,720 pointsBadges:
  • Trying to call a DB2 stored procedure in IBM System i Access

    I'm trying to test a DB2 stored procedure that's running on an AS/400 system. Our company currently has the IBM System i Access for Windows installed that runs SQL commands against the DB2 database. My big question: What is the syntax to execute a stored procedure that takes in a parameter /...

    ITKE54,720 pointsBadges:
  • I need help creating a delimitted string in DB2

    Over the past few days, I've been trying to create a delimited string from the results of a query in DB2 on iSeries. I was able to do it in T-SQL but am struggling here.Here's the code I used in T-SQL. I'm basically looking for the equivalent in DB2.DECLARE @a VARCHAR(1000) SELECT @a = COALESCE(@a...

    ITKE54,720 pointsBadges:
  • CASE keyword statement in DB2 for IBM iSeries

    I've been recently writing queries for DB2 on an IBM iSeries box. I know about the "CASE" keyword, but it's not working for me. I keep receiving this error message: Keyword CASE not expected. Here's one of my sample code: IF EXISTS ( SELECT * FROM MYTABLE WHERE KEY = xxx ) THEN UPDATE MYTABLE SET...

    ITKE54,720 pointsBadges:
  • Debugging stored procedures for DB2

    Is there a tool for IBM DB2 similar to PL/SQL Developer where I can develop a debug stored procedures?

    ITKE54,720 pointsBadges:
  • Cleaning up code in DB2

    I have a major project wherein I have to clean up some 500k string records in a DB2 environment. This entails removing line breaks, tabs, stray code, etc. Unfortunately, I'm not as familiar with DB2 as I thought. I tried to use REPLACE() and CHR() functions, but CHR() does not work: (Error: CHR in...

    ITKE54,720 pointsBadges:
  • AS/400 and DB2: Pagination query

    I'm currently working on a project in which I'm trying to create PHP web-based paging for our tables that have over a million rows. I've figured out that I have three options:Retrieve all rows in resultset (Not possible due to the size)Retrieve 1,000 rows, put in temporary table and create an...

    ITKE54,720 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following