• How to use “Program-Described-File” for converting an AS/400 numeric field into Char-field

    My situation is..... I have a file which is old & got 18,000 records in it. It has a numeric-field(Amount, Len 9,2). Now the 'Amount'Field in the file is changed to 12-char, in the new library. only this field's name is changed in order to avoid ambiguity. Otherwise the file-name & other fields...

    svankipu620 pointsBadges:
  • SQL Errr

    Hi I am a novice to SQL and I was hoping someone can tell me where I'm going wrong. I have a small sql statement that keeps giving me an error message. Can any one help please. Thank you in advance. Dawn > UPDATE AMFLIBT.MOROUT SET OPSTC = 40 WHERE (select AMFLIBT.MOROUT.ORDNO,...

    Dawn81600 pointsBadges:
  • Create QA database with only some production tables

    I have a large database with some tables that have largely static data. I need to make a new database on a different server with the same table structure with the static data tables intact (keys, etc.). The other tables must be empty. They're all in the same filegroup in the original database. I've...

    Rwaltz5 pointsBadges:
  • Generate binary dataset after weighing cases in SPSS

    Hi, I have some variables that are of binary format (0,1) and of which I produce cross-tabs. In the case that there is a weighted variable, SPSS "imputes" some of the values "weighting" them either as (0) or (1). However, there is no way to know which values have been replaced (I cannot find any of...

    Polyc5 pointsBadges:
  • Dynamically Add Picture Control in a window in PowerBuilder

    Good day, In PowerBuilder, how can I add a picture control on a specific location on a window progmatically or at runtime...?  thanks.

    Bogus215 pointsBadges:
  • Access or SQL Server tables

    Yes I am consultant for a small business, and currently they have a Access database that works pretty decently. At the current situation, the owner needs another database. I really do not want to have to ask the developer to keep creating different databases that includes him having to put more...

    Imjnice15 pointsBadges:
  • Extended ACL

    How do I create an ACL for: Allow inbound HTTP requests to the www.yzcorp server. Add info: The www.yzcorp.com website at 10.0.1.2 is registered with the public DNS system at IP address 209.165.200.246       permit tcp any 209.165.200.246 eq www is not working.

    IFOY50 pointsBadges:
  • about visual basic.net

    Hi I install vb.net ready and make connection ready, but when I try to using SQL statement it is error: my SQL is dim strSQL as string="select * from tblCustome where CustomerID="& intCustomerID the error is it does not no the string &? Please show me the solution how to solve this error! thank my...

    000015 pointsBadges:
  • updating, deleting in access with asp.net using Visual basic

    hi, i m using  asp.net 2005 usin vb. i m having gridcontrol with the back end of msaccess.  i know to retrive the data from databse by using tis code, Dim msaccessconnect, query, databasecommunication, readdatabase         msaccessconnect = New...

    Priyadharsini5 pointsBadges:
  • bmail to send mail to an exchange server

    Hello, I want to run bmail from the command prompt to send a mail.I am using exchange sever 2003 as as the mail server,when ever i enter the script it tells me that socket closed.Plz can any one help..

    Bsanneh30 pointsBadges:
  • Combining Access 2003 Queries for Dates Criteria

    I have a MainInfo table and 3 different Log tables (PleadingsLog, LitigationLog and DiscoveryLog) that are linked to the MainInfo table by an IDnumber. Each of the log tables contains a date field and a notes field. I am trying to find a way to query all records from the MainInfo table that show a...

    GCIB15 pointsBadges:
  • Software application to build database

    I'm Planning to build an application to store/update and retrieve data (say employee details) Could you please suggest me the best frontend and backend technologies to build this application?

    Serenechennai5 pointsBadges:
  • How to create data security in SQL server 2005 so that the code will not be opened

    how to create data security in sql server 2005 so that the code will not be opened

    Gkhlhlhjhhghgg15 pointsBadges:
  • How to remove the double quotes in CSV file in iSeries

    Hi The command is to remove the double quotes present in CSV file. I have used one shell command. Strqsh cmd(Sed -e 's/""//g' file name > new file name) I have to write this command in CLLE program. CHGVAR     VAR(&RPLC) VALUE('Sed' *BCAT '-e' *BCAT +                 ...

    iiiiiiiiiiiii335 pointsBadges:
  • Starting a session in MySQL

    how to start a session in my sql?

    98672129495 pointsBadges:
  • Backup process for several IIS hosted website

    Can we create an automated process for backing up several IIS hosted websites? We want 3 backups spread out over the course of the day and it should also include mySql backups as well.

    NewnanIT1,110 pointsBadges:
  • Boomi using JDBC to access DB2 in AS/400

    Want to use Boomi to access JDE DB2 What do I need to define on AS400?

    APMMRE5 pointsBadges:
  • How to move an AS/400 numeric field to an alphanumeric field without disturbing the value in it?

    How to move a numeric field to an alphanumeric field without disturbing the value in it. I have a numeric field(9,2) with value MyVar = 9876543.21 I need to move this (as it is)into an alphanumeric field(12 A), without distorting the value in it. But if I use %CHAR, it gets moved along with...

    svankipu620 pointsBadges:
  • Excel and Access integration and auto-population

    Overall, I want to create a database that tracks defects for several sites and ouputs the information in a pivot table.  Each site (7 in total) documents their internal defect data and sends it to me weekly.  I then merge all of this data (have been doing so manually) into one spreadsheet to...

    Sm6hans25 pointsBadges:
  • Advantages and disadvantages of MySQL 5.0

    Can someone explain me what are the advantages and disadvantages of MySQL 5.0??

    Espada0075 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