• Trying to use “Transfer data from iSeries add-on to Excel

    I am trying to use 'Transfer data from iSeries' add-on from within Excel. I have specified my library/file as : <><><><><><><> TANFILE/NCUFFLDR Data Option as: Select NCUFFLDR_COMPANY_TYPE Where (NCUFFLDR_COMPANY_TYPE=M)...

    CasNowak0 pointsBadges:
  • Difference between Structured Query and Query in AS/400?

    We used STRSQL- FOR START SQL(Structured Query Language) and STRQRY- FOR START QUERY. What is the difference between Structured Query and Query? (SQL and QRY)

    anupsshelke420 pointsBadges:
  • Difference between SQL Server 7 & SQL Server 2000

    Hi, Can you tell me difference between SQL Server 7 and SQL Server 2000?

    Marshal0 pointsBadges:
  • How to write SQLRPGLE query with many select criteria

    I have a report to print using SQLRPGLE. The Report criteria screen has around 15-20 select conditions. Based on the conditions entered by the user, I build a query of type: Select * from emp1 where val1 = ? and val2 =? and val3 = ? and........... This is the first time I'm dealing with so many...

    Nutangujar895 pointsBadges:
  • SQL query to find out policy numbers

    There are 2 tables POLICY and NAME. The relationship between POLICY and NAME is only the policy number. and their relationship is like many to one. I mean several policy numbers can have same name in the name table with that many records. Now my question is to find out the policy numbers having the...

    Deyyam0 pointsBadges:
  • SQL Query to return a single value for each record based on max FIELD, not max record

    I have a table with 12 date columns per record (D1 thru D12) and I want to select from each record, the max date of those columns (not the max of the records).  I know: select max(D1) from table1 will yield max of D1, but say I want D3 from record1, D1 from record2, etc (using the following...

    Schlingel0015 pointsBadges:
  • Error message CPF4326 appeared during OPEN for file EMPJ1 (C S D F). .

    Hi, I am getting the error below. What is this error...please explain it to me. Message ID . . . . . . : RNQ1216 Severity . . . . . . . : 99 Message type . . . . . : Inquiry Date sent . . . . . . : 08/18/13 Time sent . . . . . . : 14:11:56 Message . . . . : Error message CPF4326 appeared during...

    Jay1010 pointsBadges:
  • Data Conversion on IBM AS/400

    Hi, We're converting some old master files in to new format files. These master files have around 58 million records each. We wrote COBOL programs to convert the format and write to the new files. In order to speed up the process we are splitting the each master file into 20 parts(i.e., 20 files...

    DataConversion0 pointsBadges:
  • How to delete junk value records from a PF

    Hi, I have a file which has a date field of DECIMAL 8 and it has value +++++++++++ for some records. How can I delete these records via SQL or programatically.

    Ankitsikarwar10 pointsBadges:
  • PL SQL Record in Java

    Dear all, I have a Stored Package written as follows: CREATE OR REPLACE PACKAGE firstPackage IS --Type definition TYPE sampleType IS RECORD ( name VARCHAR2(128), interface VARCHAR2(128), tablespc VARCHAR2(128) ); TYPE c_mx1_type IS REF CURSOR; --procedure definition PROCEDURE iwelcome( iNum in...

    Tanmoychat0 pointsBadges:
  • Trigger or something like that for Select sentence

    I need a trigger or something which will be launch when i open a table with a "select" sentence...I know that triggers per se only work with "update, insert or delete" (DDL or DML) but I want to know if I can do something that works like a trigger but only when I do a "select" command...I know also...

    JorgeVergara0 pointsBadges:
  • How do I code this?

    LPAD(9999999 fixture,150,'') from item_loc_soh; I keep getting missing right parenthesis and I do not want the columns to display lpad or rpad

    bcarosi35 pointsBadges:
  • SQL and T-SQL

    If you are used to programming in SQL, will there be any issues with switching to T-SQL?

    lprice230615 pointsBadges:
  • To view the Oracle database table in all of the data record, will be stuck

    Query tables in the Oracle database with PL/SQL tools, can be successful, but when unwrapped all the rows of the table, will card to death. Different table, a table on the number of rows is different, but generally only 200 or so rows, then the SQL window card died (other SQL window can continue to...

    hjcj19891295 pointsBadges:
  • Where SQL statement is open ended

    Is it possible to have a where SQL statement that is open ended. I have notice that there are time that parameter box pops up with some the Access pass-through queries that I have.  Is it possible with SQL to be able to have a box pop up that would ask for a specific input to the...

    CompEng1,185 pointsBadges:
  • Compile SQLTBLSRC on AS/400

    How do I compile a SQLTBLSRC on the AS/400?

    Amartin1510 pointsBadges:
  • Reasonable SQL query

    Do you this this is a reasonable SQL query to have in an application? sSQL = "select distinct "; sSQL += " S.ChainID,S.State,S.City,S.ChainCode,S.StoreNumber,"; sSQL += " DD.DeptID,D.DeptNum,DD.DeptDesc,DD.ReportGrpid ,' ' as tax1,' ' as tax2,' ' as tax3,DiscID "; sSQL += "...

    CarlCioffi345 pointsBadges:
  • Career change for my life

    Hello to all and to all a hello. I am looking for everyone's opinions and knowledge. So please fill free to feed me your opinions and knowledge. First off I have a degree as a network Engineer and a degree in MIS. I of coarse have my MCSE and MY CNA Net + and etc. I have been involved in networking...

    Dgriggs0 pointsBadges:
  • SQL Server 2005 information

    What exactly does SQL Server 05 do and if I'm looking out for a job in this field, is there any exam which I have to take?. I'm new in this and have less knowledge about SQL. Please help. Thank you.

    Naughtyrohit15 pointsBadges:
  • SQL Server 2005: SQL statement in a variable

    Can anybody help me? "HOW TO ASSIGN A SQL-STATEMENT IN A VARIABLE". FOR EXAMPLE : TO ASSIGN A STRING IN A VARIABLE, WE DO LIKE THIS: DECLARE @A AS VARCHAR(20) SET @A='HAI' PRINT @A OUTPUT: HAI SIMILARLY HOW TO ASSIGN A SQL-STATEMENT IN A VARIABLE.

    Narendar30 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