• sql Help

    I have a ten character field and need to exclude records if the first 2 character equal a specific pattern how do you do that?

    Sjstevenson5 pointsBadges:
  • Call SQR (Structured Query Reporter)

    how to call sqr on aix and return spf to windows

    Gdcl5 pointsBadges:
  • Querying database tables with their descriptions

    I want to query an SQL server database for specific tables and their descriptions. How do I do that? Is there a special tool needed to do this?

    Sheni5 pointsBadges:
  • SQL or RPG

    Would it be better to use SQL or RPG, to update one field in the file with a value from another field in the same file? I am not that familiar with SQL, only a beginner. My RPG skills are rusty as I've not written anything in the last 4 years.

    Adeaver20 pointsBadges:
  • split column

    i need to take a column in my database and split it into different columns based on a question id. Basically i want to write a whole bunch of sql statements that are non related for one grid - a whole bunch of sql statements each with their own where statement

    Bananahead60 pointsBadges:
  • Read/Write ability to MSSQL using FoxPro 2.6 for DOS

    Hi All My company has a DOS Based Accounting system running under FPD 2.6 for DOS. We have purchased a project planning package that sits on a SQL server. I need to be able to transfer actuals from our DOS (dbase4) accounting data to MSSQL and also read from MSSQL for reporting purposes. Is this...

    Aimtek5 pointsBadges:
  • SQL order by Issue

    Please help me write this. I need a SQL where the order by is done based on a variable passed to the query.SELECT * FROM (SELECT distinct gl.group_id, gl.group_name, gl.group_description, gl.status_code, gl.member_count, (SELECT grpp.group_name FROM test_group_relationship grel JOIN test_group grpp...

    Rohit331225 pointsBadges:
  • Different Results on Insert Select than Select

    I'm struggling, along with others, where I'm getting different results when doing an Insert select verses just the select. Lots of joins to get data from various tables. Only want the first record from the uniqfield table so created the tmp_uniqfieldid table with that item fielded, creation_ts...

    Bem35 pointsBadges:
  • How do I limit my SQL output to one record per student?

    Current resuls: Student ID: Guardian 2 Joe 2 Mary 3 Goldie 4 JIm Needed results: Student ID: Guardian 2 Joe 3 Goldie 4 Jim

    Richieg5 pointsBadges:
  • I want to read a pf and build a corresponding SQL statement and save the statemnet in text file.

    how can i read pf ?as pf is colomn speciffic have to read pf like it will have feilds and some constraint, key, record. how can i build a corresponding SQL statement ? i m new in AS/400 but i have to submit this utility to my manager this thursday.. can anybody help me in providing some code for...

    0 pointsBadges:
  • My DTS package runs normally, but hangs when run as a SQL Job

    Hi, I'm trying to run an Ms Access .mbd file through a MS SQL 2003 Server. The package runs normally and works when I start the job, but simply hangs when I run the package as a a scheduled job. I've designed a DTS local package as follows:...

    Dring575 pointsBadges:
  • Output errors from SQL Server stored procedure

    I have a stored procedure using SQL Express that update a table using data from another table. All is well except that from time to time the source table might have data that causes an error. I would like to add some code to the stored procedure that will catch the error, output the details to a...

    Spionred35 pointsBadges:
  • Easytrieve – Dynamically assigning collection id

    How do I dynamically assign a collection id to an Easytrieve program? I have an Easytrieve program which is an input parm within a mainframe Proc. My SQL works fine when the collection ID is assigned on the "PARM SSID(xxxx)" statement. How can I get this value to be assigned at run type without...

    Marsh218335 pointsBadges:
  • SQL in RPG (Error when TESTING (i.e. running under ISDB) RPG program which builds SQL statement and then uses PREPARE,DECLARE,OPEN,FETCH,CLOSE)

    Under ISDB, JOBLOG showed' Internal Error 1001 has occurred SQLCOD -901' SQLCOD was ‘-901’ (i.e. minus 901) which according to manual ’SQL Programming’ is associated with Message SQL0901 – ‘SQL System Error’ SQLERP was ‘QSQROUTE’ - According to Manual ‘DB2 Universal Database for...

    TonyC15 pointsBadges:
  • Multiple Join Update

    Hi, my need is to update a table with a join of 2 other tables. The first table (a) has 5 columns (product_id number, ist number, plan number, plan_w number, ist_w number) The second table (b) has 2 columns (prod_group_id number, percent number) The third table (c) has 2 columns (product_id number,...

    Keltos25 pointsBadges:
  • SQL login client not admin

    it is payday and on the client side of our DB there are some login errors, where in SQL do you go to check points of failure?

    Deliverance40 pointsBadges:
  • Oracle SQL question

    I want to create a SQL script in Oracle that will run one of two possible SQL scripts based on what the user enters in the Parameter request. Since I'm unable to use IIF and If Then like I can in SQL Server, is there another way to do this? I have tried using case statements but Oracle doesn't like...

    Wanderer95775 pointsBadges:
  • Multiple Tables to Bulk Import .sql script

    I am a very new user to both SQL and Oracle and I am hoping that someone can explain to me if there is a way to multiple tables in a schema to .sql Import scripts. I know that in TOAD, you can right click on a table and choose export from the list, then save it as an .sql file. If I select multiple...

    ADMIntegrated5 pointsBadges:
  • Unique ID for existing table

    I want to add a column to an existing table where its values should be unique and auto generated in a sequential order

    Ragas60 pointsBadges:
  • SQLRPG MaTERIAL

    I got a task to work on SQLRPG programmes , but I am very new to this environment . Can any one send me any link about : SQL-RPG . I need from scratch. Thanks in Advance.

    Khadar90 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