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...
| January 19, 2014 8:37 PM
, AS/400 DB2
How to fill Combo Box at runtime in VB 6.0 …I’ve used RecordSet object but rec.count of rs obj returns (-1).I hv enough data in the DB
[Private Sub Form_Load() FillCombo End Sub Sub FillCombo() Dim rs As New ADODB.Recordset, SQL As String SQL = "Select Spare_Name from Spare" rs.Open SQL, Conn, adOpenDynamic, adLockOptimistic Dim i As Integer For i = 1 To rs.RecordCount cboSpare.AddItem rs("Spare_Name") rs.MoveNext Next MsgBox "Successss", vbOKOnly End Sub]
| January 6, 2014 7:49 PM
ActiveX Data Objects
, ADO Recordset Object
, Database connectivity
, Database programming
, Recordset Object
, VB 6
, Visual Basic
, Visual Basic 6
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 in my code? I...
| January 3, 2014 4:28 PM
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.
| January 1, 2014 1:51 PM
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 the column...
| December 31, 2013 6:28 PM
, DB2 query
What’s wrong with my following code for connection to a DB2 database?
| December 24, 2013 8:03 PM
, DB2 database
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 available on our system....
| December 20, 2013 4:52 PM
PowerBuilder Printing Problem
hi all, i have a problem, when i print a powerbuilder report using a network printer, from some PCs the report is blank where from some others it is printed properly. i don’t think so that the problem is in PowerBuilder because all PCs uses the same EXE. thanks in Advance.
| December 18, 2013 5:15 AM
Database Management Systems
, Microsoft Windows
, PC/Windows Connectivity
, Tech support
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!
| December 18, 2013 4:05 PM
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...
| December 17, 2013 4:02 AM