• Use SNDDST command to send email

    I'm using the SNDDST command on the AS400 to send email but its failing to deliver to users outside of my company. The emails are delivered to inhouse users but not outside email addresses. Can anyone inform why this is occuring and how to fix it?

    cmarsellus50 pointsBadges:
  • Accessing Mail Server

    I have remote users who are not allowed on the domain... At times they need to work in the main office and log in via wireless directly to the Wirelss ADSL modem/router.. putting them in a different ip range to the domain. Internet access works well with this arrangement but they are unable to get...

    Arron250 pointsBadges:
  • Looking for SQL Statement

    Hello to all, I have following problem. I have a Table containing 2 Fields: Number and Date. The content could be following: Number Date 1 26.11.2006 3 29.11.2006 3 23.11.2006 4 25.11.2006 Now I want to select all numbers, but when there is a double (or more) Value (like 3), I would like to have...

    Chilkman0 pointsBadges:
  • Using an array in embedded SQL in RPGLE

    Is there a way to specify a host array element in a where clause in embedded SQL? This is what I am trying to do: C+ Where TkPart01 = :odPart(01) C+ and TkQty01 = :odQty(01) C+ and TkPart02 = :odPart(02) C+ and TkQty02 = :odQty(02) There's more to it than that but that should give you the general...

    Vatchy1,410 pointsBadges:
  • Database Tuning Advisor “not permitted” error on SQL Server 2005 DE

    Hi! I've bought the Visual Studio 2005 Professional Edition and with it comes Visual Studio SQL Server 2005 Developers Edition. I've installed it and started developing my applications, but now when I try to tune it with the Database Tuning Advisor I get the error-message: "Tuning this edition of...

    Volrat0 pointsBadges:
  • Users/Roles/Schemas

    I'm trying to find some documentation or procedures that will allow me to xfer existing users' roles, etc from sql2000 to sql2005. When our sql 2005 database was restored on a new server (from sql2000), all of the database users were orphaned. I need to create identical server logins and then make...

    Wsyeager0 pointsBadges:
  • visal basic progect with database

    i have created an application that has a password sign in and uses ado to access a database to check if the user exists however when i create the installer and then install the program on another computer it gets an error saying that it can not find the database and gives the root directory i used...

    Neville340 pointsBadges:
  • DLL registration without local administrator rights

    Hi there We create an Excel addin using MATLAB Builder for Excel. Our IT department has taken away local administrator rights from all users of our addin. We are able to install the addin using Altiris, but how can we allow users without admin rights to upgrade to new versions of our addin? To...

    NotAnAdministrator0 pointsBadges:
  • Executing a Function or Procedure from ouside Oracle

    I have verified the code below as a valid Function and it executes from TOAD. It does not work if called from: SELECT F_T_TOTALE_TO_T_SCRAP_SC(V_TIRE_ID_EXTRACT) FROM T_TOTALE The Error is 14551. I have researched this error and it states that a function cannot be executed from a SELECT statement...

    Moonmullins0 pointsBadges:
  • Oracle Parse – Instr

    I'm receiving a string pipe delimited I need to extract the data between pipes until the end of string. How do I do this? I currently have FUNCTION fParseValue (pValueMeters varchar2) return varchar2 is v_meter1 varchar2; begin v_meter1 := instr (pValueMeters, '|', 1, 1); v_meter2 := instr...

    Dava190 pointsBadges:
  • Sending Table Data From Oracle 9i To Sql Server 2005 using oracle 9i Trigger

    My aim is to send the data from oracle to sql server 2005 whenever there is data insertion, deletion or updation in the oracle table the same change needs to happen in the sql server having the same table structure as oracle.But I am not finding any way to accomplish this task.please help me. Have...

    Dhirendra100 pointsBadges:
  • problem in server 2003

    Dear Friends I have a problem in my network. We are using window 2003 server on intel based machine in our network and all the client computers are window-xp based. My problem is there are 3 user on server, one is of Administrator level and other 2 are simple users. Admin user is working properly,...

    Sachin200 pointsBadges:
  • need to online a system

    i have finished creating the Case Registration System for a small law firm, and the firm said that they want the system tobe online, mean the system can be accessed from any places. how can i do this? how can i online a system that was created using the visual basiv? does it involved the use of...

    JienArtworkz0 pointsBadges:
  • MS SQL Server 2000

    Hi All, Can we connect remotely (from outside LAN) to a MS SQL server 2000 using enterprise manager? If so, what are the steps?

    Sudh2k0 pointsBadges:
  • can strqmqry be run as remote command

    I am trying to run strqmqry via a dos/cmd ftp session. command: QUOTE RCMD STRQMQRY QMQRY(lib/qry) ... where ... are other options I followed various instructions posted here and on as400 tech sites on how to create the query. I was able to do all of that via a dos/cmd ftp session (except for...

    Bdatadigger0 pointsBadges:
  • CPYTOIMPF Nightmare

    I am using this to transfer data from the S400 to the IFS. The data has to be tab delimited. I am the sending the data to a UNIX box. the problem is I am a getting a carriage return at the end of fields - and it appears to be random. Here is my command CPYTOIMPF FROMFILE(*LIBL/IOBEXT) +...

    Raddy590 pointsBadges:
  • OPNQRYF’s MAPFLD

    I am trying to create an OPNQRYF and use MAPFLD. I need to place conitionally one of two fields into ALPHANAME, I defined in MAPFLD. These fields are conditionally placed as follows: LNAME ===> ALPHANAME if LNAME is filled. BUS_NAME==> ALPHANAME if LNAME is blank APHANAME is defined this way...

    JohndeCoville0 pointsBadges:
  • Subquery returned more than 1 value.

    I've got a SP that has the following line of code: SET @totalLateRecords = (SELECT COUNT(*) FROM tableName WHERE tableName.fieldName <= 61)) I get the error "Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery...

    Bbonsall0 pointsBadges:
  • Single quotes around a CL variable

    The easiest way to do the above please

    Raddy590 pointsBadges:
  • Using S/36 object members (load and subroutine) on AS/400

    Hello, We are looking for IBM-supplied commands that will convert and/or run S/36 object members (load and subroutine members) to useable AS/400 system objects. The fact is that we lost the RPG source code from the S/36; so there is no source to compile on the AS/400. We look forward to your help....

    Masquita0 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