• SQLEVN70.RLL

    How do you uninstall then re-run/install SQLEVN70.RLL on a IBM M/T 8104-C10 S/NL3RF550?

    2rick15 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,240 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:
  • SQL vs RPG: Which is faster?

    Which is faster? Getting a certain number of records using a cursor with SQL or using native I/O's SetLL & ReadE?

    bogeybetsy560 pointsBadges:
  • Moving SQL into RPG programs at DW

    We are using a huge number of SQL on our production machine. We have our back up machine equal to the production machine where its located our data warehouse based on RPG. Can you help me with arguments to defense that all SQL should be moved into RPG programs at our DW?

    userjp5 pointsBadges:
  • Issue with passing data between two SQL Server databases

    I am having an issue to passing data between two SQL Server databases. I can not simply use Import/Export functions or Data Transfer Functions from SSIS because I was asked to transfer “20%” data with more than 15 criteria among 400 tables. Also we are not allowed to use the linked server,...

    274703110311274715 pointsBadges:
  • Writing a SQL Query to get two random questions

    I want to write a SQL query to get two random questions: One from first set of questions and second from second set of questions.

    Bindi5 pointsBadges:
  • SQL installation

    What is an Instance Name? What is an Instance ID?

    BlessedOne10 pointsBadges:
  • AS/400 – SQL

    I am reading a record in SQL with No Lock and its getting displayed in Screen. Based on the user input, I will/won't update the record. I want to check the record lock before performing the update statement. I don't want to check the SQL code after performing the update statement. What I want is: I...

    rajeshece1,215 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