• Is the new WRKDBF out yet?


    Yorkshireman5,520 pointsBadges:
  • SOA web service calls on DB2 RPG stored procedures


    ITKE50,850 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...

    ITKE50,850 pointsBadges:
  • save all listbox items to access DB

    Trying to save all items from a listbox, ListBox1, to an access db named CalcDB when a button is clicked, "Save To DB"

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

    ITKE50,850 pointsBadges:
  • how to set gridview column width to auto


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


    ITKE50,850 pointsBadges:
  • Problems in iSeries with Entity Framework


    ITKE50,850 pointsBadges:


    ITKE50,850 pointsBadges:
  • Establishing a connection from an IBM DB2 database


    ITKE50,850 pointsBadges:
  • Is COUNT a valid expression in SQL DB2 in iSeries?


    ITKE50,850 pointsBadges:


    ZOMGPS5 pointsBadges:


    xxsinghxx20 pointsBadges:
  • DB2/iSeries clean up


    ITKE50,850 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...

    ITKE50,850 pointsBadges:
  • PowerBuilder Printing Problem


    Ghassanhaith0 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!

    ITKE50,850 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,...

    ITKE50,850 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 /...

    ITKE50,850 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...

    ITKE50,850 pointsBadges:

Forgot Password


Your password has been sent to:

To follow this tag...


REGISTER or login:

Forgot Password?
