As400/CLLE issue
i made a PGM for read as well as write the record in DSPF but my PGM doesn`t read that PF it not showing any error .. it shows Blank value in varible. PGM                                           [...]

Answer Question   |  March 17, 2012  7:18 AM
as/400 data, CLLE, PGM

Reading multiple records from dataQ
Can we read multiple records from dataQ.How the processing is done.Please assist.

Answer Question   |  March 17, 2012  11:39 AM
as/400 data, AS/400 Routing Data

Notepad++ Regex to delete a line
Well I’ve put in a lot of time, effort, energy & it’s a complete bust. Using Notepad++ Regex, does anyone know how to “delete any line containing 1 and only 1 slash (/)”? Here is a sample file… 1. C;Directory1 2. C;Directory1Filename 3. C;Directory2 4. C;Directory2Filename 5. any text In the above sample, lines 1 [...]

Answer Question   |  March 17, 2012  8:18 PM
as/400 data

AS/400
How can i delete the datafiles within endofday script

Answer Question   |  March 17, 2012  7:34 AM
AS/400, as/400 data

No such path in wrkflr
CPYFRMIMPF FROMSTMF(‘/SANWEIGH/SANSPACE.CSV’) TOFILE(AXMTESTLIB/SANSPACE01 ) MBROPT(*REPLACE) RCDDLM(*CRLF) File system error occurred. Error number 3025. Copy command ended because of error.

Answer Question   |  November 18, 2011  7:07 PM
as/400 data

Arabic characters in AS/400 file
Hi , I have  insert some ARABIC  Charaters in  in P.F. if i am going to upddta and trying to insert cherates the cgarters are showing as ????????. Pls help  .   Thanks , Bisht   

Answer Question   |  October 17, 2010  12:30 PM
AS/400, as/400 data, AS/400 data integration, AS/400 errors, Physical Files

How to delete data from IFS directory?
How to write the program for deletion of data from IFS directory? Any cl program?  

Answer Question   |  September 3, 2010  7:49 AM
as/400 data, CL Program, IFS, IFS Commands, IFS Directory

In one of your iseries machine,history logs are not getting displayed
If the joblog for a certain iSeries does not appear earlier than a month , what might have been changed?

Answer Question   |  July 16, 2010  1:22 PM
AS/400, as/400 data

Can any one tell me how local data area and user defined data area are used to pass data between jobs?
i ‘m new to as/400.in an interview i was asked this question.give a practical example for passing information or data through local data area.I only know that data area is an object used to store tiny bits of data or it can store one value at a time and it is used to store frequently [...]

Answer Question   |  June 23, 2010  10:51 AM
as/400 data, AS/400 jobs, Local Data Area

how to declare a standalone field of 32000 bytes or more in RPGLE?
how to declare a standalone field of 32000 bytes in RPGLE? It is showing only 1024-bytes(in debug). Is there any restriction on length in RPGLE or FREE-FORMAT RPG? pls. let me know. Thanks in advacne.

Answer Question   |  April 5, 2010  11:27 AM
as/400 data

extracting data and converting AS400 date format
hi, this question is very simple I should guess.. I am trying to extract data from AS400 into excel, and since date format is CYMD, I want it to show in a MM/DD/YYYY format. Please show me how.. Thank you very much! p.s. in SQL please

Answer Question   |  February 12, 2010  2:49 AM
as/400 data, AS/400 date format

Data Extaction and Cleansing as/400
What is the best way to extract and clean data from AS/400 dbase?  We are planning to replace legacy systems with an integrated package that may have a different dbase.  Is there a good product / service?

Answer Question   |  November 16, 2009  8:46 PM
as/400 data, AS/400 Data File, AS/400 Transfer

AS/400 File Sizes
How do I determine or get a list of the files or ojbjects that are taking up the most space on an AS/400?  

Answer Question   |  April 30, 2010  5:15 PM
as/400 data

Logging user views to a record on the AS/400
Is there a way on the As/400 to know every time a user accesses a specific record?  I need to know when a user even looks at a record.  I know I can use journaling to record changes to a record as well as adding and deleting records, but as far as I know, journaling [...]

Answer Question   |  February 8, 2011  8:59 PM
as/400 data, AS/400 user sessions

Working with SQL: Extracting Data or Text within a Query, adding new column for extracted data
I have created a passthrough query in access to draw information from an AS400 system. I have also created some tables in excel and copied and pasted them into access to link them to the AS 400 query via access. So as of now I have three files in one access passthrough query. The one [...]

Answer Question   |  September 11, 2009  3:29 PM
Access Datasheet, AS/400, as/400 data, SQL

Problem in window Subfile
How can I call the window Subfile please help me

Answer Question   |  August 14, 2009  6:52 AM
as/400 data

DATA GROUP IN AS/400
hi what is DATAGROUP in AS/400

Answer Question   |  August 12, 2009  6:12 AM
AS/400, as/400 data