Junk characters in CSV conversion through CPYTOIMPF

Hi, I am sending data from iseries to excel through CPYTOIMPF i've used this command in CLLE, in query output there is a char field value is '01.03.2011' but when i see in output by wrklnk temp it shows some junk data in this field . RUNQRY     QRY(ADO150Q) CPYTOIMPF  FROMFILE(ADO150F)...

Rpgle400tech145 pointsBadges:

AS400 – SQL

I want to use Functions in Update Queries Set operation Update File Set FName = Substring(Name,1,10) Where EmpNo = 99 How to perform this one using SQL Queries    

rajeshece1,230 pointsBadges:

Active Access Database on Sharepoint

How can I load an active Access Database onto a Sharepoint Site? I need to make it open a new page and have each individual be able to enter information into it when they click on the link.

Feeneyp5 pointsBadges:

Get your free IT book: The Rails 3 Way

Here's your chance to win "The Bible for Ruby on Rails Application Development"! There are two ways to get your copy of the book that "strips complexity from the development process," answer one of four questions and post the link to your answer in the discussion section below. Another way to enter...

MelanieYarbrough6,345 pointsBadges:

In Access 2007 for query exports to Excel 2007 – How do you turn off Automatic backups

How can Access 2007 be set so that when it exports queries to Excel 2007, backups are NOT created in Excel each time the Excel file is saved?  How can Access 2007 be set so as not to cause EXCEL 2007 to backup exported query files?

2010475 pointsBadges:

Access 2003 IIF Function?

I have a form and a subform relating to vehicles. The subform has starting mileage, ending mileage and the purpose of the vehicle's use, one of which is oil change. I would like a text box on the main form to show the next oil change mileage which should be 4500 miles from the ending mileage of the...

Hld111025 pointsBadges:

Linking Fields from different tables (one table empty)

So I have 3 tables (table 3 being the issue but I have to explain the relationships for clarity): Table 1: Information is provided by Home Realtors into our online database and updated automatically to an access database on my computer. Info given: Home Serial # Home sq footage Home Location Table...

JRob15 pointsBadges:

Wireless Access Point

My Organisation is looking for some software or a way to monitor our open wireless network. We have a few access points spread around the building and we woud like a method of tracking and keeping a record of IP addresses leased and associated Mac addresses for at least 10 days.  Any suggestions...

Barcagunner5 pointsBadges:

ODBC connection and IP address

Is there a way to get the IP address of a client/server job attached to QZDASOINIT?  I can see message CPIAD02 in the QZDASOINIT job log which lists the user and IP address and I need to get this information into a CL program which runs each time the user connects to the QZDASOINIT process. ...

BISHT321245 pointsBadges:

Daylight Savings Time Change

Does anyone know how the daylight savings time change works on the AS400 in V5R3? I changed the required system values, etc and the time changed on our system just fine...but I thought the time was supposed to gradually speed up/slow down (depending on the time change) until the desired time was...

Crazyrosie0 pointsBadges:

Selecting Field Defined as L in SQL Server

I am building 4 part SQL select across 4 files using union alls. All 4 files have a date field which is one of the fields I am selecting. My problem is that on one file the date field is defined as L type where the other three files have a date field defined as 8S 0. Since the field I am selecting...

Canuhp235 pointsBadges:

Web development course and Microsoft qualifications

I recently left my job in the UK as a project manager from a niche organisation that provides business services to public service bodies. I am thinking of sharpening my skills by doing some web development training and getting certified with some Microsoft and Adobe products and moving into Web...

Tobeeornot25 pointsBadges:

TWO Free IT Books: Multicore Application Programming & The Rails 3 Way

We've got two free IT books this week. Since nobody won last week's The Rails 3 Way, we're piggybacking the books together. Both contests are currently happening, and winners will be announced Monday, March 7, 2011. The second free IT book, Multicore Application Programming, is a comprehensive,...

MelanieYarbrough6,345 pointsBadges:

MySQL vs SQL server

If I was going to get some web pages designed to interact with a database on my server would I be better using MySQL or SQL small business server? Is there a huge difference in what they're cabable of or does it just change what front-end you use? Why would I need a WAMP stack and what exactly do...

Katy20 pointsBadges:

Failover clustering in windows 2003 environment.

A SearchStorage.com reader recently asked: I want to test a failover clustering in windows 2003 environment. As am doing this at home, I don't have a SAN or Shared SCSI with me. Am struck at Shared Quorum. If am using Majority Node Cluster, is it possible to test with the IDE hard disks of these...

Andrew Burton435 pointsBadges:

Password in Delete Button in MS Access 2007

How to set a password in command button "Delete" in microsoft office access 2007 ?, that the only thing we need for our defense, please help me .. thank you !! :)

Tipsdawn10 pointsBadges:

How to count data in Access 2003 stored database

hello to all, will u please help me on how to count data in stored data in database, I am using ms access and vb6. Thank you

Tlosom55 pointsBadges:

Open IT Forum: Security Worst-Cases

Have you had rogue employees deploying to the cloud without your knowledge, that is, until something went wrong? Share your worst-case experiences including how you rectified the situation. We want to hear your security horror stories to help other members and potential rogue employees avoid the...

MelanieYarbrough6,345 pointsBadges:

Data transfer from Access 2007 to Excel 2007 stops at 65,xxx rows

How do we transfer/export data with over 575,000 rows in Microsoft Access 2007 to Microsoft Excel 2007? Is there a way to change the export data # of rows restriction of 65,xxx rows to 1 million rows in Microsoft Access 2007?

MLM10 pointsBadges:

Designing a single query using SPUFI

Hi, I am new to Mainframe..using QMF.Instead of using multiple select queries,my TL told me to design a single query.How to execute the query in SQL execution engine SPUFI??? Please tell the steps involved in creating a dataset & import the results?

Ajsjanani5 pointsBadges: