PC/Windows Connectivity

Copy and pasting cell in Excel 2002 to AS/400 application

I am trying to copy a cell with multiple lines of information in Excel 2002 and pasting it to input fields (horizontal input lines) in our AS/400 application. The problem I am experiencing is that the information will not paste or wrap correctly onto the lines (area) that I have selected. Only...

Client Access truncating blanks

I have some files that I have transfered from a AS400 with client access and it is truncating the blanks at the end. How can I not have this done.I need the blanks to stay there.

Transfer / Copy OS/2 files with Extended data attributes to iSeries

We have 1,000's of files that were originally created in OS/2. These files were created (OCR) from an image file so we could do text searches on them. OS/2 created these files with Extended Data attributes. We now need to copy these OS/2 files from an XP workstation to an iSeries networked drive....

Maping AS/400 shared folders in windows Xp

Hi, I am unable to explore the AS/400 shared folders on the PC having Windows XP Sp2, but printers are visible. There is no issue as such on OS windows 95/98. Can any one help me in this regard... Thanks satish

Mainframe to SAP

Hi, I'm a cobol programmer working on Mainframes with a work exp. of 2 yrs. I've worked in technologies like JCL, COBOL, VSAM, DB2, IMS DB/DC, IDMS, FOCUS etc. I have an opportunity to get into SAP technical(ABAP/4) as a programmer in my organisation. Looking at the future prospects of the...

Hexadecimal

Can someone please tell me the hex value of the [TAB] key Thanks

Replicating data between I-series and Ms-CRM using Scribe?

We are implementing MS-CRM on an Ms-SQL server. We need to replicate data from our business system (I-Series) to CRM, and similarly from MS-CRM to I-Series. Our Ms-CRM provider proposes using a product called Scribe to do this but has no experience of using this with I-series. Has anyone used...

Using the SNDDST command to send an e-mail from the iSeries

Tyrone wrote in with this question recently: How can I use the SNDDST command to send an e-mail from the iSeries? -- Deb Tart, associate editor

Accessing an iSeries from an SQL server

Rony wrote in with this question recently: "How can I access the iSeries from a 2005 SQL server? Please specify which ODBC I should use." -- Debra Tart, associate editor

User Auditing/Journaling

I'm new to security on the AS/400 (730). We need to have a record of what program a user calls through our ERP system or what objects are changed and who changed them. I've read some on journaling but not sure if that will work for what we need. Suggestions? Thanks Mark

CPYTOPCD

I can successfully copy data from a PF to a PC doc (via CPYTOPCD) and I can successfully e-mail the resultant PC DOC from the AS400 (via SNDDST) However, when I try to e-mail a large PC Doc (2 meg) I receive about 20 e-mails with *.DTF attachments, which are virtually unreadable. Any ideas?

PC printfiles not being deleted from QUEUES on IBM1332 used as 400 and network printers

I have several IBM 1332 printers set up to print from the AS400 and print from PC applications(EXCEL,WORD,etc) for networked users. The 400 printing has priority and then PC applications are released. We are having sporadic problems with the PC generated printing not being deleted until we do it...

Routing Entries

I am having a problem setting up my as400 routing entries to handle both our subnets and the internet. Our iseries has never been connected to the internet so this is new territory for me. Here is our original default routing entry: Route Destination: *DFTROUTE Subnet: *NONE NextHop: 176.100.1.2 ...

Error message when transferring an iSeries physical file

Dave wrote in with this question recently: I'm trying to transfer an iSeries physical file between an iSeries and a server. All is OK when I run things within FTP from the server. I've tried GET's and PUT's and the file is copied either way. However, when I try things from the iSeries and I enter...

Compressing Old Files

Hello, I would like to know the option(Compressing Old Files) which comes up during disk cleanup in win XP and win 2000. Is it good or bad? I mean, If I do the compression regularly will that effect my system/files in a long run? Is it same to that option (compress drive to save space) in disk...

Iseries Ftp Server

Is there a way to run multiple ftp servers on the iseries? I want to run server on the default port to handle ftp so when a user logs on the current library of the user profile is the default directory. I want to run another server on a given port to handle ftp from so when a user logs on the user...

To retrieve data from a remote system

Hi, I have to retrieve data from a remote system (May be of any operating system) and shall put into AS/400. This process should be automated and there can't be any manual intervention. We can not use FTP commands here. Is there any other way this can be achieved. Can?t go for MQ Series...

Printing to a HP4250 from iSeries 820

We recently connected a HP4250 by LAN to our iSeries 820. Our current OS is V5R2. There is a problem sending a report from our IBM InfoWindowII Type 3486 terminal to the printer. The font being used by the printer is very small. We have sent the report to our IBM InfoPrint20, LAN connected...

PowerBuilder Printing Problem

hi all, i have a problem, when i print a powerbuilder report using a network printer, from some PCs the report is blank where from some others it is printed properly. i don't think so that the problem is in PowerBuilder because all PCs uses the same EXE. thanks in Advance.

journal entry's entry specific data

Hi, I am trying to extract fields from security audit events. The problem comes when dealing with entry specific data field. This field contains lot of info which varies according to the entry type. Is there any API which returns information present in the entry specific data portion in a...