• What is Referential Integrity in DB2/400?

    What is referential integrity in DB2/400? & What is field reference file in DB2/400?

    40619805 pointsBadges:
  • How to write flat file data into pf?

    Hi,,  M25 is one of my flat file which is 34 char length. I want to write data from flat file to normal pf. Pf contains 3 char field which is equally devide. Now generaly to read file we have to requre key field but flat file doesn't have any key field then how i will write this pf?     

    Sms121185 pointsBadges:
  • Prophet 21 Database Dictionary

    Is there a data dictionary for the prophet 21 database? I am looking to create applications that use data stored by prophet 21 software. Is there available software to interface with prophet 21 data?

    Carlosburkle5 pointsBadges:
  • Indexing in Microsoft SQL

    What is an index in Microsoft SQL? What types of indexes are available in SQL Server 2005? Do I need to know about this to create and deploy a database?

    TeachMeIT975 pointsBadges:
  • Edit a text file with VBA

    Cheers, I have large text file that needs to be edited to run a job but I would like to automate the process.  How do I open a file and replace line 132 of (which is about mid of the file) that file? Thanks, Bob

    Rjwilcox45 pointsBadges:
  • Exceeding maximum record locks in Access

    i have written code to import information from several text files into a linked table. It works fine for a while, but eventually I always get an error about exceeding the maximum allowed locks. I do not want to change the registry - i would rather just not have any locks (because I don't need them).

    Rampagingpigeon25 pointsBadges:
  • dba deleting data

    Is part of a DBA's job to delete production data using SQL scripts?

    Biker015 pointsBadges:
  • SQL Work Files

    In the FOCUS programming language, you can retrieve data and hold that data for further processing at some point later in the program.  What is the best technique for doing this in SQL?

    Rhansard5 pointsBadges:
  • Connect to remote SQL server from MySQL

    we have read only access to a remote sql server. the requirement is to read few tables from sql server and load to mysql tables (installed on Unix box). Please suggest the possible ways of achieving this.

    Nitibansal5 pointsBadges:
  • System Administrators Access in a HR/Payroll System

    Hi I have taksed to define the access rights for sys admins for a HR/Payroll system. The thoughts are divided among the groups here - one, the segretion of duties that should limit any type of user to perform tasks end to end since this is a payroll system; two since it is a sys admin access the...

    Cognos20015 pointsBadges:
  • Client Loves User-Level Security, But Needs Access 2007

    Hey Guys, I have a Client for whom I have remodeled an access database. The database was initially created in Access 2003, and has been updated in 2007, though it is still in .mdb format. I showed the client a few simple user-level security options, and they worked like a charm. The only problem is...

    Washkuhnw90 pointsBadges:
  • SQL problem: Adapting code fragment

    How do I adapt the fragment of code below to show: a) Two columns - the Filipino Population and the Total Population  b) The Filipino Population as a percentage of the total population  SELECT DISTINCTROW POPDATA.CITYNUM,  COUNT(*)FROM POPDATA  WHERE POPDATA.ANCNUMBER=720  GROUP BY...

    Mentos5 pointsBadges:
  • Can you embed SQL statements in RPG program

    I am new to AS/400 and we have a project wherein we have to display the records grouped by some fields. Is it possible to write sql statements within RPG program?? How???

    Shwesmile20 pointsBadges:
  • RRN and JOIN…

    I have two files and I'd like to join and make a group-by on a xycod, in order to count the number of occurrences. This is the question: What happens on the RRN filed when i try to do group by statement? There is one-to-many relation between records and RRNs, so which is the RRN assigned to it?

    Devilva15 pointsBadges:
  • dBase locking

    Why is it when one certain user is in the DBASE no one else can get in - but when everyone else is in and this user isn't, she still is able to get in - all our settings are the same - Shared, no locks and the open database by using record-leveli locking is unchecked, this person was checked but i...

    Stallojc5 pointsBadges:
  • Subquery in Microsoft Access

    [em]   Trying to create a subquery for a table in Access.   I am trying to pull out of a table all records where Sales amount is greater than 1000 and the discount rate is less than 5%. I have to calcuate the discount percentage in the  table, and don't want to create another table with that...

    Miltonfung5 pointsBadges:
  • Recovering data from crashed database

    i   i have a question. my database  is crash .i don't have present backups.but i'm having  last week backups.  and  backup  strategy sunday   10 p.m  full backup everyday  1 p.m    differential backup every one hour transaction log backup  please give me reply as soon as thanks &...

    Venkatdbait35 pointsBadges:
  • Sending an email with a link to a .csv file that’s too large to email

    My program creates a .csv that is copied to the IFS. It is too large to attach to email. I want to send an email with a link to the file. How do I do that?

    Kprazor45 pointsBadges:
  • How to use the data from other table into the main table in Access 2003 and 2007

    I'm trying to use data from other tables to make a sum and then display the result in a "Total" text. For example: I have in table1 3 qty's, in table2 2 qty's and in table3 5 qty's. I want to sum all those qty's and display them into the Main Form. I use MS Access 03 and 07

    Eddy20 pointsBadges:
  • Create SQL statement in VBA Access 2007

    How can I create a select Group BY SQL statement inside a VBA module? I've ran actions queries and they seem to take an effect in my tables but I'm having a difficult time creating a Select statement. Please display a couple of samples

    Bostic8620 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