• Data migration strategies

    Hi All I am embarking on a Data Migration project which involves migrating data from one I-Series database application to a different I-series database application. I guess as with all migrations the data does not excatly match in both appplications. I have identified that i need to populate Excel...

    Hazermark0 pointsBadges:
  • The most-watched IT questions this week: Dec. 15, 2009

    Here are the 10 most watched questions on ITKE: There’s some great discussion going on. Go answer a question now! 1. Ak1bo78 asks for a C# how to on IF Statement’s, which Mshen and CarlosDL help create. 2. Dbsi2006 asks for help on how to map drives without UNC, which Rklanke, MrDenny,...

    Michael Morisy8,588 pointsBadges:
  • The IT Blog Top 10: Dec. 10, 2009

    10. No Exchange 2007 on Windows 2008 R2 – but why? Brendan Cournoyer delves into why the latest Windows 2008 R2 takes a surprising turn in not support Exchange 2007. 9. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees explains a helpful VBScript trick. 8....

    ITKE435,865 pointsBadges:
  • The most-watched IT questions this week: Dec. 1, 2009

    Here are the 10 most watched questions on ITKE: There’s some great discussion going on. Go answer a question now! 1. CompEng asked about open-ended SQL statements, and Mrdenny and Meandyou delivered the goods. 2. Kalpana queried Networking certifications, and where the best place is to get...

    Michael Morisy8,588 pointsBadges:
  • The most-watched IT questions this week: Dec. 8, 2009

    Here are the 10 most watched questions on ITKE: There’s some great discussion going on. Go answer a question now! 1. Pushan1234 asks about Returning string value from a stored procedure in sql server 2005 to vc# ide code at runtime. CarlosDL and MrDenny provide some pointers. 2. Bonbon78 runs...

    ITKE435,865 pointsBadges:
  • Performance Problem

    We are experiencing intermittant performance problems most likely related to the update of a file that saves emails sent to customers. The problem may be related to a 10,000 byte text field for the body of the email message and/or the size of this file (2 million records). The file has one index...

    Ashnirody100 pointsBadges:
  • Generating Excel spread sheets from Sequel on the iseries

    I produce an excel spread sheet from sequel on the as400 and e-mail it to a user. The user performs some data entry on the spread sheet. The spread sheet is then transfered to a AS400 Physical file and a program is called that updates a AS400 data base. The problem is when they enter 013, the...

    Johnd0155 pointsBadges:
  • The most-watched IT questions this week: Nov. 24, 2009

    Here are the 10 most watched questions on ITKE: There’s some great discussion going on. Go answer a question now! 1. Cluster drives moving windows server 2003 r2 32 bit was asked by a reader and answered by Mrdenny. 2. Migrating to virtualized environment purely to retain support for legacy...

    Michael Morisy8,588 pointsBadges:
  • numeric field check

    i have a file that has a numeric field that is being cleared early in a program if certain conditions are meet as the file is being made...i need to check later before that file is printed to see if those conditions have changed....the numeric field is the key....it's not having zeros put in...

    Cowboypgmr0 pointsBadges:
  • Formulating a backup policy for data generated by terminated employees.

    Our company is trying to use best practices where possible to formulate a policy to cover the backup, storage, security, retrieval and retention of data from the PCs, home drives and Exchange mailboxes of employees that have terminated employment. Our company is publicly traded so the...

    SearchStorageATE215 pointsBadges:
  • triggers

    i know you can attach a trigger to a physical file, but can you attach one to a print file or even a display file. thanks in advance

    Cowboypgmr0 pointsBadges:
  • How do I confirm all the data moved from Source to target for different tables

    How do I confirm all the data moved from Source to target for different tables. I am not able to phrase this question. Bottom line I want to make sure all the data was transferred to target database. That is my test to validate. Thanks

    Gvsatyam5 pointsBadges:
  • Data Dynamic Activ Report Version 2.0

    I Have Data Dynamic Active Report Activex, When I load designed Report from vb6 I can show a evaluation message in yellow backgroun How to remove it and also when I give print 1 page printer will print 2 page (With blank page) How to solve this problem or how to hack this proble

    Jadejaashok60 pointsBadges:
  • The IT Blog Top 10: Nov. 19, 2009

    10. The intermediate IBM i 6.1.1 version Mark Fontecchio takes a look at IBM i 6.1.1, and answers the question of how well it fills the gap for those waiting for i5/OS. 9. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover explains some important adminsitration techniques for...

    Michael Morisy8,588 pointsBadges:
  • pl/slq procedures – POSITIVE and POSITIVEN as IN OUT parameters

    Hi, I have a simple PL/SQL procedure with IN and OUT parameter of type POSITIVEN. CREATE or REPLACE PROCEDURE PROC ( inval IN POSITIVEN, outval OUT POSITIVEN ) AS BEGIN outval := inval; END; I pass the value 1 for the IN value using the sql type INTEGER in a jdbc application. But oracle throws a...

    Kanapo5 pointsBadges:
  • The IT Blog Top 10: Nov. 12, 2009

    10. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees offers up an indispensible guide for VBScripters. 9. Standard Server 2003 Migration to SBS 2008 Part 3 Roger Crawford’s third part of his series on Server 2003 migrations. 8. Success of 64-bit Internet...

    Michael Morisy8,588 pointsBadges:
  • How to combine variables

    In my data set, I have four variables that have the same codes in them. The four variables relate to the same question that was given four different times to the same people. How do I get all of their responses under one variable so that I can work with it

    Onw3320 pointsBadges:
  • Showcase Query 8.0 CDs or DVDs

    I did an upgrade to V6R1 before I did an update to our Showcase Query Suite.  I am looking for a copy of the Showcase Query CD or DVD for Showcase Query Suite 8.0 released after September 2008. If anyone has this and would be willing to send me a copy please let me know. SPSS cannot ship any media...

    MNBV15 pointsBadges:
  • The IT Blog Top 10: Nov. 5, 2009

    10. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover has put together a useful tutorial for Sun’s xVM VirtualBox. 9. How to reset the Cisco Catalyst Switch to Factory Defaults Yasir Irfan offers some advice for those needing a fresh late on Catalyst switches. 8. Independent...

    Michael Morisy8,588 pointsBadges:
  • Effective ways for retrieving millions of records from a table?

    I have two tables -- [em]Users[/em] and [em]UserAddress[/em] -- with 30 million records in each.

    SQL Server Ask the Experts2,585 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.

Thanks! We'll email you when relevant content is added and updated.

Following