• 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:
  • Complex sort for SQL Query?

    I have a table: MY_TABLE IDENTIFIER (VARCHAR) NAME (VARCHAR2) DATE (DATE) SELECT NAME, IDENTIFIER, DATE FROM MY_TABLE ORDER BY IDENTIFIER, DATE; So that works great for ordering the identifiers (basically making them look like a grouping in the output). Then sorting them by date (makes it sort...

    KGNickl50 pointsBadges:
  • Database

    How to create a database of prison management system using SQL?

    abuhafsah25 pointsBadges:
  • Oracle first or SQL

    Hello Everybody, I would like to learn Oracle. The question is: should I learn SQL before I start to learn Oracle? Why? Thankx Zaid

    Zaid198140 pointsBadges:
  • using SQL in RPG

    I want to use the following 2 SQL statements in 1 RPG program and have the results print out. How can i accomplish this task? Not sure how to do even 1 SQL statement and have it print, let alone 2. Select RNSREGN region, COUNT(RNSINVN) #Orders, SUM(RNSQTY) #Books, SUM(RNSTOT$) $$ from...

    rmb115 pointsBadges:
  • Link to file in IFS – file not found error.

    To avoid sending very large SQL results through the email system I have created a command to place the file in the IFS and just send a link to the user via email. When I click on the link to open the file, it opens right up. When the users click the link, they get a "file not found" message. Why? I...

    Jsuper25 pointsBadges:
  • Best Technology for learn

    i m the computer graduate doing job in technical support & wants to learn new technology can u suggest any new technology

    santosh1234567891030 pointsBadges:
  • need help with measuring dates

    I am trying to select records from a table where the CREATEDT field is between SYSDATE and 20 days prior. select distinct(createdt) from U_table where to_char(createdt, 'dd/mm/yyyy') between to_char(sysdate, 'dd/mm/yyyy') and to_char(sysdate - 20, 'dd/mm/yyyy') There are records in that table that...

    jkeri360 pointsBadges:
  • Group By con ORDER By en V7R1

    Hola, antiguamente en la V5R4, cuando escribiamos una sentencia SQl que utilizaba GROUP BY, el sistema solo ordenaba por los campos definidos dentro del GROUP BY, ahora , en la V7R1, no lo hace, y me obliga que escriba el ORDER BY y a continuacion los campos de Ordenamiento, cabe aclarar que el...

    2602196240 pointsBadges:
  • Sql Search

    Hi, I have a Search box on my site at top. Where visitor can enter any keyword. I have Full Text Search enabled on my DB and index the Columns. I have one Columns SalesTitle in one of Table Catalog.Product, which contains almost our required keyword, like ProductNumber, Description, BrandName,...

    Mr. SEA130 pointsBadges:
  • how to store the radio buttons checked value in a database (sql)using vb.net

    Iam having 2 radiobuttons in my web form rbown and rbrent for the user to selcet whether he owns a house or he rents.I assigned own and rent as text propertis to the 2 radiobuttons and groupname as group1. Iam trying to store the text values depending on the selection of the radiobuttons in the...

    Anupamak1515 pointsBadges:
  • Using Decode in oracle sql query for Debtors Analysis Report

    i have a table called transactions in my oracle database which stores data for employees under particular employers. each member has an account and employer_id with transactions , the table has fields as below. TRAN_ID, TRANTYPE_ID, PENSION_ACCOUNT, EMPLOYER_ID, TRANAMT, SALARY, TAXEDAMOUNT,...

    wiri5 pointsBadges:
  • SAP HRP 1000 & 1001

    Hi For a recent Datawarehouse building activity, we'r to pull data from one of the SAP HR System to our SQL Database. I'm not much familiar with SAP and hardly have any idea about SAP internal architecture and I need ur help thus. I was told HRP 1000 Has all the object details and HRP 1001...

    Mkiva5 pointsBadges:
  • Training- SCOOP Inc.

    I'm thinking of taking some training from SCOOP Inc. They offer iSeries training (Java, SQL, RPG etc.). Have any of you taken training from them? If so what did you think? Pros? Cons? Would you recommend them? Let me know. Thanks!

    Dantheband0 pointsBadges:
  • ABAP/BI career.

    Hi, I have total 4 year of exp on ERP development & customization with sql dba & 1.5 years on sap-abap. at present i am working as sql dba. i want to change my current sql dba profile to SAP. Please tell me which is the best option for me sap-abap or sap-bi or sap-bw. is sap-bi or sap-bw are the...

    NitinVarshney20055 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