• Oracle SQL and compare date

    Hello! I need help. I want to compare two dates and count how many days its between them. Example: 2006-09-22 and 2006-10-06 results: 14 days Hope for help. Thanks!

    MissNew0 pointsBadges:
  • Get all table names by SQL

    Hi, How can I get all the table names of a bib by a SQL-query? Thank you.

    Oli0015 pointsBadges:
  • Problems using SQL CONNECT to a remote server within an RPGLE program

    Let me apologize in advance if I fumble with the terminology and don’t explain myself as clearly as everyone is probably accustomed to. The specific situation I’m dealing with involves the need to have an RPGLE program on the iSeries connect to a data base that resides on a remote server. My...

    mikechance81275 pointsBadges:
  • Notrix formula

    I have a Notrix job which is transferring data from Notes to SQL.  I have a date field that appears on the form 03/27/2013 but comes over to SQL as 27 Mar 2011.  I haven't had too much experience with Notrix and have only done some trim formulas. I tried @Trim(@Date(FIELD)) and it brought back...

    MSNotes10 pointsBadges:
  • JDBC in SQL

    Need example to retrieve data from JDBC in SQL?

    Msatbh85 pointsBadges:
  • SQL insert error in php

    When my php executes the db2 insert, I get error 7008. Any ideas what I might try to get it working ? The PF is new with *all public authority and no trigger nor journal. I manually added 1 record via green-screen SQL with the same context as what is assembled in my php. Here's the actual code in...

    aceofdelts1,930 pointsBadges:
  • Numeric value error

    How to solve this Error ORA-06502: PL/SQL: numeric or value error: character string buffer too small.

    avk86510 pointsBadges:
  • Inventory transaction using Crystal Reports Visual and SQL

    I have created a report with all parts in our warehouse with part location, qty and transaction dates. Since there are various locations with qty(or no qty) and various transaction dates linked to them, I can not max and get the info I need. I need all parts that have qty (or no qty) in their...

    AVLJACKIE5 pointsBadges:
  • SQL Studio 2005 expired but it is not evaluation copy?

    What happened? SQL Studio 2005 says evaluation period has expired even though I have a licensed copy of SQL Server 2005 installed. Please help.

    Nan57225 pointsBadges:
  • SQL message with no records selected

    I have two user profiles, one will show data and the other does not when I do a simple Select * from myfile. I get a message, 'Syntax check found no errors.' I am *SECOFR on both profiles, library lists appear to be the same. Ideas anyone? Thanks in advance, Nick

    NickHutcheson11,380 pointsBadges:
  • Trap SQLCODE from RUNSQLSTM

    I have a RUNSQLSTM that updates a table. When it hits a duplicate, it quits and returns SQL9010. What I want it to do is just skip the step that got a duplicate and move on. Is there a way to do this?

    khalon15 pointsBadges:
  • Compiler

    Which compiler should I use in SQL?

    kitukisu5 pointsBadges:
  • Expression to insert value to a table column in SQL

    My CL program has RUNSQLSTM. The SQL source has some SQL statements(source is of type SQL) which inserts value to a file. I need to change the SQL to have a column(FLD1) value like this (A*B*C)/10**D. A,B,C, and D are file fields. The attributes are like this A- (15,2) B- 13 C - (13,5) D - 1 I have...

    RamvishakRamesh2,505 pointsBadges:
  • Entry Level Vendor Neutral SQL Certification

    Hello, Can anyone recommend an entry level vendor neutral SQL certification? I am looking for a cert that is focused on SQL coding rather than learning a specific database. I want to get into database programming and show that I know the basics such as normalization, querying, joins, etc. Thanks...

    MG357805 pointsBadges:
  • AS400 to Oracle query

    Can I query a Oracle database directly from AS400 using interactive SQL.Will I need to install any driver or is there a way around?

    Atti123135 pointsBadges:
  • DFU to SQL translator

    Is there a package that will allow the user to enter DFU commands and then translate to SQL and send that to the processor? The situation is that the logging program doesn't see DFU commands but does see SQL statements.

    DandyDon10 pointsBadges:
  • PLEASE HELP SQL CODE

    need some help, my code is below as follows with my questions indicated by *. SET ECHO OFF; SET FEEDBACK OFF; SET TERMOUT OFF; SET HEADING OFF; SET PAGESIZE 400; SET LINESIZE 600; SET NEWPAGE 0; SET TRUNCATE ON; ***at this time i am truncating the whole document how can i just truncate a specific...

    Alex88090 pointsBadges:
  • Debug

    How to debug an SQL Stored Procedure?

    bigT35 pointsBadges:
  • sqlcmd :0 rows updated

    When I run exec dbo.subprogram from sql server management studio, it executes and returns result as many rows affected: But when I run from cmd C:\Users\mssadmin>sqlcmd -S servername -d databasename-q "EXIT( exec dbo.subprogram)" it retunrs as 0 rows affected. What could be the problem

    Beena5 pointsBadges:
  • SQL SERVER

    The SQL Server mobile edition is supported on?

    siphesihle10 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