• 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:
  • 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:
  • SQL logging

    How do we prevent our SQLRPGLE programs from creating so many job log records when executing?

    COOPERL10 pointsBadges:
  • Is there any GUI tool in Java to make a map of seats in a classroom for seat allotmment

    I want to develop a graphical seat allotment software, for which I want to make a map of the area and then visually allot seats (like in cinema theaters). Is there any tool already available in Java for this?

    hussain22juzer500 pointsBadges:
  • Trouble creating SQL statement from MS Access Form

    I'm creating an INSERT statement from the text fields in a form. This is a snippet: mySQL = mySQL & Combo0 & "','" & Text3 & "','" & Text5 & "','" & Text7 I am alternating the double and single quotation marks to enclose the entire statement as a single STRING while...

    MarcC5 pointsBadges:
  • Can somebody provide me SQL questions based on various situation?

    I have started working on SQL DB. During an interview question, there were various situations given through which we need to write some queries. Questions/ Situations where UNION , ORDERBY , JOINS , DATE Functions and others are used. Can somebody provide me SQL Join situation questions for...

    Mayurkhe295 pointsBadges:
  • AS/400 – iSeries SQL Update of on table with values from another joined table

    I've use an SQL utility on the AS/400 call SEQUEL by ASC, that allows updating of values in one table from values in another joined table. The syntax is something like this: update set((a.fld1=b.fld1)(a.fld2=b.fld2)) from file1 a join file2 b on a.key1=b.key1 where a.key1='OnlyTheOneIWant'I no...

    Mark90990 pointsBadges:
  • SQL update a column to remove a certain character

    I have a table (book) where there is a column that contains number in some rows and numbers with an addition *infront. I want to be able to perform some calculation with the table but the '*' is preventing me from doing this. So how do I update or alter the table so that I can remove the * and keep...

    Lazy16755 pointsBadges:
  • SQL update command to update certain digits in a row of a column with VARCHAR2(9) DATATYPE.

    Please I need an SQL command that I can use to update only the fourth and fifth digits in a particular column in an Oracle 9i database.The column has a VARCHAR2(9) datatype. My Oracle database is on Windows 2003 environment. Eg: The row in question reads '063150987' and I want to replace the fourth...

    IdongesitDaniel5 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