• Internal vs Externa Stored Procedure Performance

    Our company develops software for Windows using C# for connecting and updating the corporate database in DB2/400. We use both internal (SQL) and external (rpg) stored procedures. Because we have noticed some bad performance in our internal stored procedures, we have the following question: Is there...

    Baron4005 pointsBadges:
  • Do Businesses still need SQL Server?

    With all the upgrades to MySQL, has SQLServer needed to step up its game or do you think business still needs SQLServer?

    ITKE409,350 pointsBadges:
  • DB2 image copy that is no longer in SYSCOPY on zOS operating system

    We have a tablespace that needs to be restored from an image copy which we have the problem is the image copy is not recorded in SYSCOPY. We also tried doing a UNLOAD FROMCOPY thinking if we got the data out of the image copy we would be able to load it back into the table. That also failed with...

    EPPERSON5 pointsBadges:
  • Transposing data in Access table

    I have a Access table with 2 cols - Mothers Name and Childrens Date of Birth. Table contains about 20k records and Mothers Name is repeated for as many children she has (i.e., Mary, 03/09/1992, Mary 05/21/1996, Mary, 12/13/2002). My goal is to have an Excel spreadsheet with cols as Mothers Name,...

    Dcathib5 pointsBadges:
  • Error when trying to drop a table that doesn’t exist in RUNSQLSTM

    If I try and DROP a table that does not exist the RUNSQLSTM will fail. Is it possible to monitor for this in the RUNSQLSTM so it won't fail?

    Gingertosser10 pointsBadges:
  • AS400 ODCB table link

    When i link tables with a ODBC driver then some table won't give me any records (I link into microsoft access. But I do see the column headings. I the record fields I get: #Name? Is this an AS400 problem, ODCB or Access ?

    Davidfromnetherlands15 pointsBadges:
  • User Files

    How do I copy user rights and access priveleges from one as/400 to another and still have access to both systems?

    Gw325 pointsBadges:
  • How use the file of more than 8 characters long in Foxpro without ~ marks

    how use the file of more than 8 carractor long in foxpro without giving ~ marks

    Arvind136685 pointsBadges:
  • merging of two files in foxpro2.6

    how to merge two files in foxpro

    Sahuja5 pointsBadges:
  • Print User Permissions

    Using MS Access 2003, is there a method to print users and permissions for each user?

    Mrit13065 pointsBadges:
  • Enabling Database Archiving Lotus Domino

    We have always written lotusscript to archive documents from databases. We don't use Notes mail, so I was never exposed to the standard archving functions. I have now set up archiving for one large database so it should only hold 7 days of data. Older documents go to an archive database, which is...

    Brooklynegg3,845 pointsBadges:
  • FoxPro Report Preview Hangs

    When previewing an existing report, FoxPro freezes momentarily every time you change the page and recovers 1 min later

    Xcellent5 pointsBadges:
  • SQL connection failure error handling

    Application group wants batch job to terminate if it is unable to establish SQL session to external database. Job log indicates MSGID QSQLMSG/SQ30080 "Communication error occurred during distributed database processing.   This appears in the joblog as a level 30 diagnostic message. When this...

    Midranger25 pointsBadges:
  • Access form -updating details for Not in list

    I have created a form "Transactions" for data entry. One field, "Account", selects from an existing list, but can accept new Accounts. When I accept a new account, I would like to be prompted to go to the "Account" form and fill in the Account description on 4 additional fields (Title, Category,...

    FsAccess5 pointsBadges:
  • Storing array values into an Access database table from a program

    Hi, I’m trying to write a program that stores the values in an array into a database table. The name of the database is Company.mdb and the table that I want to store values is called Employee. Below is the procedure that is supposed to perform the task. The problem is it doesn’t store the...

    Zigzagzig10 pointsBadges:
  • getting VLAN working between netgear switch fs726t and WG102 AP

    Hi everyone, Im setting this up for a church and well stright to the point..... I am trying to set up 2 SSID's on the AP both on diffrent VLANS I have a cisco 1700 router connected to the switch(FS726T) and have VLANs configured already on both the router and switch. (They work) On the switch I...

    Davidbrown0020 pointsBadges:
  • How to save data back to databse from radio button? SQL Server 2005

    I am using 4 radio button, what so ever radio button I select, so how data revert back to database, I am doing this in asp.net 3.5 using sql server 2005

    Shaktilpu15 pointsBadges:
  • SQL Join on multiple columns?

    Can I join from one file to another on more than one column? For example, join from FileA to FileB on OrderNumber.A=OrderNumber.B AND ItemNumber.A=ItemNumber.B? All examples show only one column... I am on an AS400 using RPGLESQL, I need to join from one detail file to another detail file.

    Wlakesearcher100 pointsBadges:
  • Packed fields in Flat Files

    I have a flat 400 file wich is 36 long internally described as follows: 1 2 0ICL 3 6 0ORDNO 7 8 0SUB 9 11 0DEPT P 12 13 2RATE P 14 18 2TOTMTH P 19 23 2OTODAT P 24 28 1HRS2DT 29 36 0INFODT I creasted alogical as follows: R DLLOHD PFILE(DLPLOHD) ICL I SST(DLPLOHD 1 2) ORDNO I SST(DLPLOHD 3 4) SUB I...

    JAC260 pointsBadges:
  • Creating a database in Access 2007

    I am not an expert on Access; however, as a student in college my professor commented that my Microsoft Database was built from a table. Can someone tell me what does that mean? And do your templates build from a table? I guess I really want to know how to prevent a template from building a...

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

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

Following