• 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:
  • 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:
  • Testing how long an SQL script will takfe to run

    Running Oracle 9.2.x. We have to sun a couple of SQL scripts that will make some changes to tables/data. Is there a way of finding out approximately how long these scripts will take without actually running them? Is there some tool I can use to do this? Or some rule of thumb?

    Pingsc0 pointsBadges:
  • Blue Socket Gateway and Certificates

    We are currently attempting to implement a Blue Socket Gateway in order to authenticate our wireless clients. I have been instructed by Blue Socket that the certificate used by them will not work through a NAT translation and that I should put this device on the outside of my ASA firewall....

    Skepticals0 pointsBadges:

    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:
  • SQL Stored procedure call via ODBC

    Trying to call a stored procedure via ODBC, the CA400 ODBC driver uses the SQL (as opposed to SYS) conventions this works fine when procedure is created in QGPL and procedure is called with CALL QGPL.MyNewProcedure(Parm1,Parm2,Parm3) when the procedure is in another library then the call does not...

    Teckgeck170 pointsBadges:
  • How to prevent XSRF attacks

    I've been hearing more about XSRF (cross-site request forgery) attacks. (Netflix most recently had to fix a flaw related to this.) I'm wondering how you can prevent this type of attack. Do Web application firewalls work?

    Coder6270 pointsBadges:
  • Creating DB2/400 Table Dynamically

    Hello, I need to create DB2/400 table from CL or COBOL with some column names which are defined dynamically. How to do this ? Thanks

    NarasimhaReddy225 pointsBadges:
  • Urgent Help: web-Forms 6i don’t work after Upgrading the db from 8i to 10g

    Hi, We have web-Forms 6i that are deployed on a server A and run against a database installed on a server B. The database was recently upgrated from version to 10g AND moved from the server C to the server B. However we're using now for the server B the alias we've used for the server C....

    1081080 pointsBadges:
  • Isolation level… Join new JAVA development with old, outdated COBOL code…

    Anyone have experience dealing with JAVA and isolation levels? The concern or talk at this shop is how to handle current old COBOL code with new JAVA code with record locks. All Cobol code runs batch mode. Reads daily transaction file to update files. The new world, Java, will be interactive update...

    Znason460 pointsBadges:
  • accessing password protected hd

    Hello everyone. Computer A crashed unexpectly. It turned out to be the motherboard but what im concerned with is the hard drive. I put the hard drive from computer A into a spare IDE slot on computer B. I booted computer B with computer B's own hard drive and attempted to grab the files i needed...

    Whobettrthankyle0 pointsBadges:
  • Tools for DDS to DDL migration

    Hi, My Profile: I have a legacy DDS defined DB2/400 database and my IT staff are telling me that for true SQL/ODBC access we either need to migrate the database over to DDL defined tables or add unique indexes to the existing DDS structure. My Question: Do we really need to alter the DDS database...

    Newbie4000 pointsBadges:
  • ODBC connections

    We have a database that is specifically designed for our industry. We want to be able to export the information into a mailing list. This is the email that I received from IT. "You cannot export to an access database, but you can connect to the KIDS database with Access or with Excel query to...

    Jade057110 pointsBadges:
  • VB.Net of Visual Studio.Net 2003 VS Visual Basic 2005 Express Edition

    Good Day! Would be appreciate if there is solution for the following problem: - In VB.Net of Visual Studio.Net 2003, developer can click and drag a table listed in the Server Explorer from a connected database to the form. This will add OleDbConnection control and OleDbDataAdapter control to the...

    Hunkgym5 pointsBadges:
  • Connect:Direct CDSND command

    Has anybody used this software to send data? We are sending a native file, and were wondering if there was a way to have the file converted to tab delimited on the CDSND command? Or, do we have to tab delimit it to the IFS and CDSND from there ?

    Raddy590 pointsBadges:
  • dynamic visual basic form based on access database table

    I am useing an access database table to populate some lists. I want to dynamicly add picture boxes that I use to seperate the list box as if lined based on how many records I have in the database. Basicly, I just need to know how to add a control by code. I don't want to have to place 100 picture...

    YitoGraft0 pointsBadges:
  • Web Server and DC to share database

    From what I've read, it is "Best Practice" to keep your web server separate from your AD Domain Controller. What if they need to simultaneously share the database? My local users will be logging in to the AD locally and using an app that accesses a database. No problem. My remote users use a PHP...

    BandHSolutions0 pointsBadges:
  • Simple but not so

    I have 2 table 1) Product_Inf and 2) Product_attribute_details I have prod_key, dye_class, prod_range in both the table. Their is no relation exist between both the table than how can i find the records available in Product_Inf but not in Product_attribute_details?

    Ilink880 pointsBadges:
  • FTP using *SSL

    I am running v5r3 and am attempting to FTP to a Tumbleweed Securetransport server from our iSeries system using the command: FTP RMTSYS(xxxx) PORT(999) SECCNN(*SSL) I get the following response: Connecting to host xxxx at address xx.xxx.xxx.xx using port 999. 220 qweb1 FTP server (SecureTransport...

    Wctick0 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.