• 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?

    ITKE346,195 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:
  • MDE files

    Okay so I converted my mdb file into an mde file so that no one else can edit or change things in the database but you can still edit in the mde file how do i make it so no one else can change or edit my database info but me

    ItnewB5 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:
  • RRN Max

    Is there a way to allow more than 1 billion records in a DB2 File? We have reorged to file to get rid of deleted records, but are still out of room. The system will not allow one more record to be added because we have reached 999,999,999 records.

    Nay ray5 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:

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