• SFTP

    I need to transfer a file using SFTP. It's a PF with a 180 character field. When I try the put command from an iSeries library, the file goes over as binary. If I copy it to the IFS and transfer from there, it goes over as text. But, I cannot have this unencrypted file in the IFS, even temporarily....

    CandyS30 pointsBadges:
  • SQL update a column to remove a certain character

    I have a table (book) where there is a column that contains number in some rows and numbers with an addition *infront. I want to be able to perform some calculation with the table but the '*' is preventing me from doing this. So how do I update or alter the table so that I can remove the * and keep...

    Lazy16755 pointsBadges:
  • SQL update command to update certain digits in a row of a column with VARCHAR2(9) DATATYPE.

    Please I need an SQL command that I can use to update only the fourth and fifth digits in a particular column in an Oracle 9i database.The column has a VARCHAR2(9) datatype. My Oracle database is on Windows 2003 environment. Eg: The row in question reads '063150987' and I want to replace the fourth...

    IdongesitDaniel5 pointsBadges:
  • Difference between ODBC and JDBC?

    I'm writing a Java application. In short, this application needs to connect to DB2 on an AS/400 for some SQL data. I cannot find a straightforward comparison of ODBC and JDBC. Do any of you know where I can find one? Or, have any of you done java programming with the intent to connect to AS/400 SQL...

    Schmidtw11,330 pointsBadges:
  • Count distinct rows on multiple columns

    I want to write a single query that counts each distinct Student ID from the following sample data. Sample Data: ID NAME PLAN DESCR --- ------- ---- ------------------- 101 Michael 010C Cafe- 10.00 Dollars 102 Adam 010C Cafe- 10.00 Dollars 102 Adam 05CC Cafe- 5.00 Dollars 103 Jane 010C Cafe- 10.00...

    Mjackson0 pointsBadges:
  • Runtime Error 3001 – Arguments are of the wrong type or out of acceptable range or are in conflict with one another

    Dear Sir, Thanks for your answer for my earlier questing. It solved my problem I am using VB6 as front end and Access as back end. I'm editing my table for particular field. I am editing rate of one item in RMmaster file. It's doing it, but I want to edit rate of same field which is in another...

    RajeshP20 pointsBadges:
  • Install SQL server client tools

    With client utilities like query browser, or query analyzer...how do I install on client workstations? I am not interested in installing a SQL server. I should just be able to query a SQL server and display some results from my laptop. Can anybody guide me? Well, if we have to buy any licenses we...

    Krblr200720 pointsBadges:
  • I want to select months from Jan to Dec using SQL query

    I want to select months from January to December using SQL query. I will use this for list item note:- without using PL/SQL and less union.

    44063860 pointsBadges:
  • Advantages of database system over file systems

    What are the advantages of database system over file systems?

    Michael Tidmarsh29,825 pointsBadges:
  • Using SUBSTR with interactive SQL

    I am trying to change part of a field using the substring command in interactive SQL. To do this I entered the following: UPDATE LIBRARY/FILE_NAME SET SUBSTR(FIELD_NAME1,194,4) = 'XXXXX' WHERE FIELD_NAME2 = 99999 I get the error token ( was not valid. Valid tokens: = .' Obviously there is a syntax...

    GHENDER190 pointsBadges:
  • DB2 Date function to convert number to Date

    In Cognos-Framework Manager there is a calculation in the DB2 section called "Date". Supposedly this field will change a numeric date "01012005" to an actual date "01/01/2005". But, we tried it and it does not work. Can you see if you can find anything that will allow us to create a calculated...

    Meenac0 pointsBadges:
  • ORA-06502: Character string buffer too small

    Hi guys, Here's my script I have created aggregate string function 'Tab_To_String' using this below script CREATE OR REPLACE TYPE t_varchar2_tab AS TABLE OF VARCHAR2(4000); CREATE OR REPLACE FUNCTION Tab_To_String (p_varchar2_tab IN t_varchar2_tab, p_delimiter IN VARCHAR2 DEFAULT ',') RETURN...

    Kruti123456789shah15 pointsBadges:
  • Capture a photo through webcam with Visual Basic 6

    I want to capture a photo by clicking a button in VB 6.0 through webcam and store it to a desired location. How can I do it?

    Hanny5 pointsBadges:
  • How to create a CSV file in PHP code?

    I need to create a physical CSV file from PHP code. I have many solutions to get the results to print to a screen, but I need a file... any ideas?

    Texmansru4725 pointsBadges:
  • Rollback command in SQL

    Suppose user x insert values into table t1,and then update the table t1. After then he wants to increase the size of column c1. Then he wants to rollback to update values. He can do this or not? If yes then what is the right procedure?

    10111986105 pointsBadges:
  • Passing parameters to report viewer

    Hi Kindly excuse me if I appear a bit ignorant on this subject as I am relatively new to SSRS. I have managed to create a report that has 3 parameters (ie. Start Date,End Date,Drop down list) which I have successfully deployed to Report Server. The report basically uses a stored procedure which has...

    Shaygen5 pointsBadges:
  • Mac address to IP address resolution

    How can we resolve IP address from Mac address and can we do this from Cisco switch 3750? We are able to track port no and associated Mac address from Cisco switch by using the command #sh mac-address-table dyanamic>, but we also want to track the associated IP address with port no. Please...

    Ruchitgarhwal0 pointsBadges:
  • Concentrate more than two fields together into one field in SQL

    Say I have 3 columns: 1st name, middle name and last name. How do I merge the 3 columns into one column yet separate the content with commas?

    Sammy545 pointsBadges:
  • USB External Hard drive and Windows XP

    I have two issues which are basically the same. I have an external USB hard drive that I connect to a computer running Windows XP. Windows USB driver recognizes the hard drive and shows the drive in Device Manager but Windows does not show the drive in Windows Explorer. A customer has a USB FLASH...

    Cestanley0 pointsBadges:
  • How to create our own set up file in VB 6.0

    Dear friends, I want to know how to create setup file of our project in VB 6.0. Wait...I know how to create setup file using package and deployment tool but I want to know how can I create a file in which we can include images, pictures, some animations. I mean setup file with our own ideas and...

    Rajevinayak0 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