Database Tag Directory

Featured Database Questions

Operating Console
Hi I have operations console running on a laptop which is directly connected to my I-Series. All runs okay until the laptop powers down(for variety of reasons), when i power it on again it will not connect to the I-Series without doing an IPL of the I-Series. I get the message “Connecting Console” and it...

Answer Question   |  April 15, 2014  2:52 AM
AS/400, Backup & recovery, DataCenter, DB2 Universal Database, Security
asked by:
0 pts.

How I can convert FXP to PRG? (Foxpro-2.6)
I have lost of my Foxpro 2.6 .prg file. I have only .FXP foxpro file. I want to convert .FXP to .PRG. Remember I have long statement in PRG (above 255 characters). Give me a proper solution. Thanks & Regards Narayan Gadri.

Answer Question   |  April 2, 2014  12:14 PM
FoxPro 2.6
asked by:
5 pts.

How Would You Define Database Concepts?
I am recruiting for a DBA for an ecommerce company and so far every candidate I have submitted to the HM has been rejected as they “do not understand database concepts”. Circling round to the rejected candidates they all comment the HM is asking programming questions yet when I ask the HM and present a...

Answer Question   |  March 27, 2014  7:21 PM
database concepts, DBA, SQL
asked by:
5 pts.

Eternus DX60 – Failing NL-SAS disks
Hi, We are currently using a Fujitsu Eternus DX60 with NL-SAS disks as storage for our virtual machines. During the last 18 month 8 out of 12 disks had to be replaced because the system claimed them to be failing. Fujitsu Support told me that this is totally normal. Since our support contract will end within the...

Answer Question   |  March 25, 2014  12:20 PM
Drive Volumes, error, Fujitsu, SAN storage
asked by:
15 pts.

File access denied problem in FoxPro 2.6
Our package is having the prob: When making buildup (index) of re-create CDX file.making to open of exclusive database files. I think improper shutdown of coming this prob. That time nobody access this file. Standalone machine only and reboot the machine also. but “FILE ACCESS DENIED” ERROR MESSAGE SHOWING. How do I sort out this...

Answer Question   |  March 19, 2014  1:49 PM
FoxPro, FoxPro 2.6
asked by:
10 pts.

Problems with printing in FoxPro 2.6 for DOS
I have a foxpro program it is ok but when i try to print it will show error that your printer is not ready. Anybody have .dbf printing file??

Answer Question   |  March 17, 2014  6:35 PM
FoxPro 2.6, FoxPro 2.6 for DOS
asked by:
5 pts.

How to add database in Foxpro 2.6
I’m running build/generate app file, but after generating the run app file, the display alias is not found.

Answer Question   |  February 27, 2014  12:38 PM
FoxPro 2.6
asked by:
5 pts.

Indexing keys in Foxpro 2.6
I indexed a file to many keys. Some keys have the index tag but some aren’t indexed.

Answer Question   |  February 25, 2014  11:51 AM
FoxPro 2.6
asked by:
5 pts.

Logical files – V5R4
HI we all know DSPDBR command on a PF will fetch all the dependent logical files. Can anybody tell me with a logical file’s name only known is it possible to fetch the Physical files’s name on whom it is dependent?   happy new year n best wishes to all Ram

Answer Question   |  February 14, 2014  12:53 PM
DB2/400, Logical Files, V5R4
asked by:
1,150 pts.

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 not able to manually...

Answer Question   |  February 2, 2014  10:34 AM
DB2, DB2 Table Relationships, Mapping table relationships, Table Relationships
asked by:
5 pts.

Microsoft Outlook error occurred.
Microsoft Outlook must be closed because an error occurred. Any unsaved work may be lost. what do I do it comes up every time i am in outlook. It seems to be trying to send 2 items but I can’t find them.

Answer Question   |  January 13, 2014  3:50 PM
error
asked by:
5 pts.

Send group invitation on Outlook 2010
I have a group list i made. But i keep getting an error that says “Only users with SMTP email addresses can be invited” Does anyone know what this means or why it is happening?

Answer Question   |  January 2, 2014  9:40 PM
Calendar, error, GROUP, INVITATION, Outlook 2010, Outlook 2010 Calendar, SMTP
asked by:
5 pts.

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.

Answer Question   |  January 1, 2014  1:51 PM
AS/400, DB2, DB2UDB, i5, iSeries, WRKDBF
asked by:
5,520 pts.

SOA web service calls on DB2 RPG stored procedures
I’m trying to centralize our business logic so that it calls up our web services (SOA architecture run on Spring HttpInvoker) from DB2 RPG stored procedures. I can’t get it to work, so is what I’m trying to do actually possible? 

Answer Question   |  January 1, 2014  6:19 PM
DB2 RPG, SOA and Web services
asked by:
54,900 pts.

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

Answer Question   |  December 31, 2013  6:28 PM
DB2, DB2 query
asked by:
54,900 pts.

Problems in iSeries with Entity Framework
Working in AS/400 withDB2Connect with Entity Framework, trying to create a EDMX file in iSeries.  I can see that records have been produced but cannot save them. I get this error message: ERROR [55019] [IBM][AS] SQL7008N REXX variable "INVENTORY " contains inconsistent data. My initial research suggests the problem is that the table is not...

Answer Question   |  December 24, 2013  4:07 PM
DB2Connect, EDMX, Entity Framework, iSeries AS/400
asked by:
54,900 pts.

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 = 'IPADDRESS'; $User = 'USER'; $Password = 'PASS'; $db = ADONewConnection('db2');...

Answer Question   |  December 24, 2013  8:03 PM
DB2, DB2 database, PHP
asked by:
54,900 pts.

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!

Answer Question   |  December 18, 2013  4:05 PM
AS/400, DB2, DB2/400
asked by:
54,900 pts.

We’re looking to add a field description in a DB2/400 file
My partner and I have a set of files on an AS/400 system but we don’t have DDS for (the files were created in SQL). We would like to add field descriptions but we’re struggling to find how to do this in AS/400. Could someone tell me how we can add a field description? Is...

Answer Question   |  December 16, 2013  12:33 AM
AS/400, DB2/400
asked by:
54,900 pts.

How do I update rows in DB2?
How do I update rows in DB2. When I used SQL, I was able to go forward with this: update top (100) table1 set field1 = 1 This doesn’t work in DB2.  Any suggestions on what I should do instead?

Answer Question   |  December 11, 2013  8:39 PM
DB2, DB2 Update Query
asked by:
54,900 pts.

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: