• Embedded SQL in an RPG FREE program

    I am developing an on-line screen program, where the user can select a view of the data from a list of "views". This is my first crack at embedded SQL, Basically i issue the Prepare, declar the c1 scroll cursor, and then open c1, and then do the fetch. At this point I am loading the subfile. First...

    Merts30 pointsBadges:
  • Oracle Forms 6i and Oracle 11g database – Multilingual I18N

    HI, We have Forms 6i, we are going for Multilingual, and it has Oracle 11g db. We are updating the database with one more column in an exiting table with NVarchar2. The approach we are going for Column level Character set Updates. One more approach is Full Database level Character Set. I try to...

    Gguruji5 pointsBadges:
  • Numbers of records in flat file without opening it?

    Can we find the number of records in the files using the parameters Space used , Space allocated, LRECL, BLKSIZE in mainframe or are any other parameters required. I have to find the no of records without opening the file or even accessing it. Is it possible.

    K19085 pointsBadges:
  • Delete duplicate values in Microsoft Access

    there was a ms access database in which there 3 to 4 values same so i want to delete the values keeping only one value. so i need a query.

    Kimidiramana30 pointsBadges:
  • CPYTOIMPF –FLDDLM(*TAB) QUESTION

    Our OS is V5R4. I am using cpytoimpf to import .txt file (tab delimited) to DB2 physical file. If I remove the FLDDLM(*TAB), I get all the records but the fields have overlapped data. If I use the (*TAB) I get one record and errors on the remaining copy.(error code 7) Here is the command I am...

    VRSTEEL5 pointsBadges:
  • Oracle OLAP degenerate dimension

    Hi, How to declare a dimension as degenerate dimension in oracle Analytic workspace manager(AWM) tool? Is there any other tool to achieve this or any manual process involved? Thanks in advance, Vinay

    VinayOLAP30 pointsBadges:
  • Tables, queries, and database with Visual Basic 6

    hi i am developing a visual basic application with (vb6.0)and have the following questions,1. how will i add a table in my application and then use one column to be getting data from another table. 2. can i make a query in .mdb and then run it in visual basic.how will i do it if its possible, i...

    Ndonye5 pointsBadges:
  • How to use Store Procedure for multiple column database update?

    I created a store procedure to update a table based on values from another table using inner join. 15 records need to be updated but when the store procedure is executed no rows are updated bu the return value is 0.

    KjitSingh5 pointsBadges:
  • Database Management Systems

    what are the basic steps in implementing a database management system?

    Twa895 pointsBadges:
  • Small Business Server 2008 backup error message for Shadow Copy Service

    Using SBS 2008 and get the following error when doing a backup "A Volume Shadow Copy Service operation failed. Unknown error (0X800423F4)" The application event log shows event id: 12290 Any suggestions

    123456300 pointsBadges:
  • For 4 columns, I want just one to be “X”

    I want to have one culumn to be "X" like "4" - all the rest can be whatever number aside from "4". How do I do it?

    KC2420 pointsBadges:
  • SQL Server vs Oracle comparison

    what is the difference from sql and oracle in detailed?

    Geta5 pointsBadges:
  • How to create a Microsoft Access form that generates a spreadsheet with parametered values?

    Hello, I have a table that has this type of fields (almost 26,000): Cia Type Account Type Call flag Country Client code related main include China 5765 not related auxiliar not include USA 3372 related auxiliar excepted USA 981 related auxiliar include China 789 In access I need to create a Form...

    Codino10 pointsBadges:
  • How to implement One-to-One and One-to-Many class associations using VB.NET 2005?

    I have designed a solutions for a Student and Employee Management system using Object Oriented concepts and techniques. I'm doing this management system as a Graduate Project. Now I'm stuck in implementing the association relationships. Can anyone help me on this. Answers using code examples would...

    Obhasha0795 pointsBadges:
  • subform

    I have one table and a main form and a subform. All fields for these form are in this table. The subform is called from the main form via a command button. When I go to the main form and go to, say record 3, it displays the correct data, but when I use the command button to open the subform the...

    Donb5225 pointsBadges:
  • Mainframe batch DB2 table I-O monitoring

    Dear Sir or Madam: I can examine the excp counts for flat, VSAM, IMS files in the JCL batch JES JOB Log statistics, both while executing & when job has completed. How do you monitor that I/O for DB2 tables? Thank you, Michael Piccolo

    Pic40 pointsBadges:
  • How can i make only one administrator to accsess database through C# application,and without registering this administrator in atable in the database?

    How can i make only one administrator to accsess database through C# application,and without registering this administrator in atable in the database?

    Hanafy5 pointsBadges:
  • SQL query to list databases that have a given table

    Hi all I need your help for creating some SQL query that returns the names of all databases that have a given table name. Ex. I'd like to run this query against the master database and search for all databases that have a table called "customers". Is it possible to do this, if yes how? Thanks in...

    alessandro.panzetta9,725 pointsBadges:
  • Database Access 2007

    Hi, I have created a database and created a query with some fields from my main table. Now I would like to add more fields but I can't any hint? When I go into my design mode those new fields do not apper?

    Ld23315 pointsBadges:
  • what is the max length for an sql cursor name?

    what is the max length for an embeded sql cursor name in RPG?

    TheMarkWTaylor5 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