• retrieving run time records in SQL

    how to retrieve multiple rows at run time in sql

    Sasthri5 pointsBadges:
  • Documenting column in SQL table in QADBIFLD (AS400)

    When a table is created with SQL, several fields in the system cross-reference file QADBIFLD gets content (headings, defults a.o). I noticed that the QADBIFLD table contains a column named DBIREM (length 2000 bytes..). I also noticed that the old S36 IDDU actually put some documentation into this...

    DanTheDane2,555 pointsBadges:
  • RPGLE/SQL PROBLEM

    I am trying to join our sales analysis file, all fields, with our accounts receivable file using SQL. I can extract the information okay but when I issue the following fetch command: FETCH NEXT FROM SALESSORT INTO :SALESREC ,:CUSTREC it skips the null records. I have spent the last 6 hours...

    Burtmis100 pointsBadges:
  • Using SQL and Postgre on the same machine

    We have a requirement in which we need to have our Microsoft SQL Server, as a database of tomcat servers, and our Postgre SQL, as database of jboss servers, on same machine. Are there any known conflicts or issues we should be aware of?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Auditing users of STRSQL

    I want to audit the SQL statements of users who use STRSQL. I know if you press F13, you can change the interactive SQL Session Services. If you choose option 4 it will save all SQL statements into a file. But I was wondering if it is possible if we setup this as default when starting up STRSQL? So...

    AS400 - Ask the Expert485 pointsBadges:
  • SQL Access Query

    I am using the book SQL for Microsoft Access. and the below statement is from the book and for some reasone I am getting a sytex error on the  word "Udate"     Why would that be?  CREATE TABLE Manufacture ( ManufactureID INTEGER CONSTRAINT ManfID PRIMARY KEY, ToyID INTEGER NOT NULL,...

    CompEng1,185 pointsBadges:
  • Multiple databases on a server – SQL

    My queries Can PostgreSQL(as database for a Jboss application) and MS SQL(as database for a tomcat application).Are there any known conflicts/issues ? Best regards

    Rajg5 pointsBadges:
  • about oracle with Java

    What is future of Oracle with Java regarding jobs for freshers and distance learners. Why I am asking this because I am learning oracle from SQL star tutorial in delhi and doing MCA from Sikkim Manipal University in distance learning.

    Qqqq10 pointsBadges:
  • Querying multiple member PF with SQL

    I would need to SQL on a multiple member PF and I need to query the 2nd or nth member in the PF.  Is this possible just with an SQL query without using OVRDBF etc.?

    Rajgoaj280 pointsBadges:
  • File overrides within interactive SQL sessions – how are they applied?

    I have an issue where, in an interactive SQL on an iSeries (V5r4) despite specifying the library and file name for a delete statement, the action deletes from a file listed in the overrides. Is there a way to prevent this from happening?

    Nephilim5 pointsBadges:
  • SQL for MS Access Syntex issue

    I have started to read the book by Cecelia L. Allison and Neal A Berkowitz on SQL for Microsoft Access.  and there is a syntex listed below that has been giving me a problem.   I get an error with the word UNIQUE.  So I removed it from the statement and then I get an error with the ON section...

    CompEng1,185 pointsBadges:
  • Difficult Select Statement in SQL

    I have a table with columns, to wit: FieldA FieldB A U B V C A C A C B D A D A D A E B E B E B I can get the records that are multiple in FieldA but whose values in FieldB are repeating with: Select FieldA, FieldB from table  group by FieldA, FieldB  having count(*) > 1 And the result will be:...

    bogeybetsy560 pointsBadges:
  • Different results for embedded SQL

    I have embedded SQL in my RPG code and some of the results are different to what I get when I check using STRSQL

    Macitmich20 pointsBadges:
  • Query Calculation Part of Select Criteria

    This query works great except I need to add one thing. There are two district codes that need to be included in the query. These codes just need the MC_Tax_Amount field totaled - no dividing by two. How do I add this to my query? Thank you, SELECT "T16.CPRP".CP_DISTRICT_CODE,...

    lorit365 pointsBadges:
  • Need help executing MULTIPLE SQL extracts from a JCL

    GREYBEARD52: Thanks again for the info, BUT I'm not sure if a CL command can be used with a JCL. Can it? ALSO, my JCL uses the SELECT command, so it appears that the RUNSQLSTM command won't help - it doesn't support SELECT. Are there ANY OTHER ALTERNATIVES or a way to tweek this command to 1. Run...

    Jonty Walker105 pointsBadges:
  • Why does the keyword END is not accepted at the end of a stored proc ?

    Hey guys,  I have thise error in SQL stored proc.  I'm on ISERIES and I use RUNSQLSTM to very my procedure. could you help ?  It's seem I can't put a END at the end! ---------------------     160            AND DUDGCT =...

    FRANKIA5 pointsBadges:
  • Textbox input to a a sql dataset table in Vb.net

    How do I input data from textboxes in Vb.net to ...a table in a  data set ....and then display generated data back to some more textboxes ???? I am using sqlexpress ....Thx. mace100

    Mace1005 pointsBadges:
  • I NEED SQL COMMAND TO EXTRACT THE NUMERIC VALUSE IN BETWEEN THE STRINGS

    VCH:FR:AUD/120.18/51.26YQAC/1.35QKAD/14.47QRCO/14.47QREB/1.35QKSB/6.00WGSE/20.91UOVZ I NEED TO EXTRACT THE VALUES IN THE ABOVE STRING AND SUMM ALL THE VALUES USING SQL COMMAND EX:120.18+51.26+1.35.....IN THE ABOVE GIVEN REFRENCE

    UUKKY15 pointsBadges:
  • Sound from .net

    how can I save and retrieve sound wav files to and from sql database using vb.net?

    Semauel8515 pointsBadges:
  • Migration from Paradox to MS Access or VB.Net/MS SQL

    We have a department that has several applications running on Paradox 11.  They need assistance migrating their tables and application UI/code to another platform.  Any feedback or guidance would be appreciated.

    ScotE45 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