• Dynamic SQL in RPGLE

    I am building a dynamic SQL in RPGLE with a wildcards. It does not work like a native SQL statement. A search for "FRANK" will search on 6 characters (retrieve all the FRANK and the FRANKL, but not the FRANKLIN). A search on "FRANKL" will retrieve the FRANKL and the FRANKLIN. Any help would be...

    davidgrant10 pointsBadges:
  • SQL database only with LDF file

    Is it possible to restore a SQL database with the latest ldf file because the MDF file is corrupted? I was hoping that data is still there. I actually have a backup of the MDF file of last month. But the MDF file this month is damaged, and the ldf file still normal. Can I use the. MDF file backup...

    ArturKis25 pointsBadges:
  • How to create 5 table in LEFT OUTER JOIN

    How do I create 5 tables in LEFT OUTER JOIN?

    shibinfelkees5 pointsBadges:
  • Oracle FK Dependencies

    A query I run accesses multiple tables. One of those tables has a FK dependency on a column, which is populated by the application and hardcoded as a single value for all records. So in the where clause when im joining all the tables to get the data required, it is only pulling data for that...

    Rishik015 pointsBadges:
  • SQL Primary key and surrogate key

    When surrogate key is generated automatically, then why is a primary key required?

    Lavanya925 pointsBadges:
  • How to get nth highest salary using SQL/400 query

    Hi, How can I get nth highest salary from a PF named EMP having two columns EMPID and ESAL need to retrieve nth highest salary using SQL/400 query. Here N may be first, second,third any no.  Thanks!

    6r1,850 pointsBadges:
  • Dynamic SQL in RPGLE

    How can I build a dynamic SQL statement for input from a screen file?

    davidgrant10 pointsBadges:
  • Oracle SQL: Retrieve data for previous week

    I am trying to retrieve data for the previous week. I need to get the previous week starting on Monday and ending on Sunday. How can I retrieve the data from Monday to Sunday? For example, today is 10-Aug-2016. So, I need details from 1-Aug-2016 to 5-Aug-2016 as week day, and 6-Aug-2016 to...

    rajeshgudla5 pointsBadges:
  • SQL on multi-membered file without overriding

    How to query on a file and retrieve data from any of the members of the file without overriding to any of them?

    vishwaraja5 pointsBadges:
  • Oracle In Linux

    How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.

    Samachar0 pointsBadges:
  • SQL database rollback query

    How do I roll back in case the database changes all data to the same information?

    twatonny015 pointsBadges:
  • Rename SQL database table

    For my SQL database, I have to rename one of my columns. What's the process to do that? Will a specific query work for this? I just have to change the name.

    ITKE828,900 pointsBadges:
  • Getting a missing expression error when inserting from another table

    INSERT INTO dst_case1 (email) values  SELECT (email_addr) FROM siebel.S_CONTACT@TCCP.TMS.TOYOTA.COM where dst_case1.customer_id=siebel.S_CONTACT@TCC

    paramu775 pointsBadges:
  • Compare three SQL Server columns

    I have 3 tables table1 has the column id1 with three values in it '1','2','3' and table2 has column id2 with three values '3','4','5' and table3 has column id3 with three values '5','6','7'. How do I join all the three tables, and I also want the null value to be displayed. Please go through the...

    harish978920 pointsBadges:
  • Problem with character alignment on output or retrieval of variables

    We have an issue we have never seen before but I'm sure happens all the time. We have a DDS screen where the character's are shown as follows:- RETAIL LOGISTICS                     : £99.00 RETAIL FREIGHT                         :£120.00...

    Sxlad200145 pointsBadges:
  • Server settings incorrect when scheduling Crystal Report on SQL 2014

    Getting the following error message when scheduling crystal report on SQL 2014. Failed: 450 : Report Engine : Wrong number of arguments or invalid  property assignment If I generate the report directly in Crystal it is correct - no problems.

    myann590305 pointsBadges:
  • Avoid read locks on SQL database

    For my SQL database, how can I avoid read locks? Should I use a SQL statement for this? Thank you!

    ITKE828,900 pointsBadges:
  • INSERT two SQL tables into new table

    I have two SQL tables and they're both pretty large. But now I have to combine all of their column names into a new table and, for some reason, I don't have permission to click on each table and choose CREATE to SCRIPT. So how can I go about doing this? Basically, how can I use INSERT both tables...

    ITKE828,900 pointsBadges:
  • How to check if SQL row exists using PHP?

    How can I check if a SQL row exists using PHP? I'm currently using MySQL. Could I use PDO (PHP data object) to do this? Thank you so much.

    ITKE828,900 pointsBadges:
  • List Microsoft Access database tables using SQL

    Would there possibly be a way to list all of my tables in a Microsoft Access database using SQL? I know how to do it in SQL Server but not sure of the command in Access. Thanks!

    ITKE828,900 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.

Thanks! We'll email you when relevant content is added and updated.

Following