f



How to use AS400 journaling?

Hi,

I am using V5R4. Is there any way to see a table journal in the form
of SQL that was actually run on it? Can I see that at some date and
some time, someone did an UPDATE, or INSERT or DELETE? Can I see the
full SQL query that was executed (sort of like what is saved with
interactive SQL sessions, but for all users)?

The output of DSPJRN is very criptic, I'm looking for something
simpler.

1
10/9/2007 9:59:31 AM
comp.sys.ibm.as400.misc 9219 articles. 3 followers. Post Follow

6 Replies
1203 Views

Similar Articles

[PageSpeed] 52

On Oct 9, 5:59 am, simun.se...@gmail.com wrote:
> Hi,
>
> I am using V5R4. Is there any way to see a table journal in the form
> of SQL that was actually run on it? Can I see that at some date and
> some time, someone did an UPDATE, or INSERT or DELETE? Can I see the
> full SQL query that was executed (sort of like what is saved with
> interactive SQL sessions, but for all users)?
>
> The output of DSPJRN is very criptic, I'm looking for something
> simpler.

You'll have to start a database monitor job to see this but there's no
way to limit it to a particular table. You can limit it by job and I
think user (this option is new to V5R4) or you can start one for the
entire system but you'll need lots of free DASD to store all of the
information it produces and it will slow the system down.

Matt

0
matt.haas (139)
10/9/2007 12:35:37 PM
   SQL is not the only way to delete or insert rows.  The program name 
and job attributed to the action defines the where, the user defines the 
who, and of course the date/time defines the when; what the identified 
program does, defines the how [to the level that is available], and 
typically requires going to the program source.  What the entry types 
are, define what the request was, to the row level anyhow.  The SQL 
statement is not logged.  There is currently no DML statement audit or 
journaling, included in the file journaling.  The journal function on 
the system does allow /user/ entries to be sent by an application, so an 
application could log [SNDJRNE or an API] any of its static or dynamic 
statements.

   FWiW I have never found the DSPJRN cryptic, because it provides a log 
of all of the row activity.  The log allows knowing effectively every 
detail but the why and how.  The why and how fit better in the domain of 
debug.  Those are details unnecessary to recover from mistakes or to 
recover from loss of the file.  The how is known in part from the 
program named as having requested the action.  Seeing that the action 
was a delete, it is a known that the request was a delete of that row. 
Knowing the SQL statement is the how and possibly part of the why, which 
again, are more aligned with debug versus logging.  That the user U 
deleted [per R-DL] a row from the file at time T in job J for unknown X 
while running program P tells a pretty thorough story.

   When using logging for debug, journal entries can be sent that are of 
interest to the [debug of the] application.  When the application logs 
instead of the system, then the system is not logging tons of stuff 
other than the actual log of row activity to the file.  The logging of 
row activity is really what journaling is all about, enabling either the 
apply or remove of those changes to be performed in the event that some 
form of recovery is required.  So although logging a dynamic statement 
that had given an unexpected key value, for example in a WHERE KEY_FIELD 
= 'Key Value', knowing that statement explains how the deleted rows were 
chosen, but still nothing about why that statement was built with the 
wrong key value or even why that program was even called.  If all such 
statements were always logged, all of the extra output could make the 
function cumbersome rather than apparently cryptic.  Such extra logging 
sure would be a nice addition to the feature of /debug messages/ for SQL 
activity; i.e. SQL itself sends the fully resolved statement while debug 
or trace are active.

Regards, Chuck
-- 
  All comments provided "as is" with no warranties of any kind 
whatsoever and may not represent positions, strategies, nor views of my 
employer

simun.selak@gmail.com wrote:
> I am using V5R4. Is there any way to see a table journal in the form
> of SQL that was actually run on it? Can I see that at some date and
> some time, someone did an UPDATE, or INSERT or DELETE? Can I see the
> full SQL query that was executed (sort of like what is saved with
> interactive SQL sessions, but for all users)?
> 
> The output of DSPJRN is very cryptic, I'm looking for something
> simpler.
0
crpence (662)
10/9/2007 1:29:28 PM
"Can I see that at some date and some time, someone did an UPDATE, or INSERT 
or DELETE?"

Most certainly.  All that information is available in the fixed part of the 
journal receiver record.  From a green screen, prompt a DSPJRN command for 
journal name, file name, date/time range, journal codes, etc. as needed to 
limit the amount of data returned.  Then on the resulting display you can 
use 5=Display to see the fixed part of each record and use F10 and F11 to 
see the detail.

Go to the iSeries Info Center 
(http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp) and search 
for "Journal code descriptions" for more info on what each type of journal 
record reflects.

The last field in a journal record can seem cryptic, since it is byte by 
byte dump of the actual record.  There are ways to look at this on a field 
by field basis if you want to see what changed, but by far the easiest is to 
Google EXPJRNE and install that piece of free software.

"Can I see the full SQL query that was executed (sort of like what is saved 
with interactive SQL sessions, but for all users)?"

Not from the journal, as far as I am aware.  If you need to do this, you may 
want to investigate iSeries Navigator and look at starting a database 
monitor.

Sam

<simun.selak@gmail.com> wrote in message 
news:1191923971.635369.72340@19g2000hsx.googlegroups.com...
> Hi,
>
> I am using V5R4. Is there any way to see a table journal in the form
> of SQL that was actually run on it? Can I see that at some date and
> some time, someone did an UPDATE, or INSERT or DELETE? Can I see the
> full SQL query that was executed (sort of like what is saved with
> interactive SQL sessions, but for all users)?
>
> The output of DSPJRN is very criptic, I'm looking for something
> simpler.
> 


0
none9415 (338)
10/10/2007 12:41:34 AM
You may consider to use my EXPJRNE command (Freeware) to gain a better look at the journal entries. 
The EXPJRNE command retrieves the selected journal entries from the journal and puts them into an 
output file with the same layout as the original file plus the journal information.

    http://www.tools400.de/

Direct access:

    http://www.tools400.de/English/Freeware/Utilities/utilities.html

Beside the EXPJRNE command you also need the BASICS1 and RTVFLDA service programs. Both service 
programs are available for free, too.

Thomas Raddatz.



simun.selak@gmail.com schrieb:
> Hi,
> 
> I am using V5R4. Is there any way to see a table journal in the form
> of SQL that was actually run on it? Can I see that at some date and
> some time, someone did an UPDATE, or INSERT or DELETE? Can I see the
> full SQL query that was executed (sort of like what is saved with
> interactive SQL sessions, but for all users)?
> 
> The output of DSPJRN is very criptic, I'm looking for something
> simpler.
> 
0
10/10/2007 6:07:43 PM
On Oct 10, 8:07 pm, Thomas Raddatz <thomas.radd...@tools400.de> wrote:
> You may consider to use my EXPJRNE command (Freeware) to gain a better look at the journal entries.
> The EXPJRNE command retrieves the selected journal entries from the journal and puts them into an
> output file with the same layout as the original file plus the journal information.
>
>    http://www.tools400.de/
>
> Direct access:
>
>    http://www.tools400.de/English/Freeware/Utilities/utilities.html
>
> Beside the EXPJRNE command you also need the BASICS1 and RTVFLDA service programs. Both service
> programs are available for free, too.
>
> Thomas Raddatz.
>
> simun.se...@gmail.com schrieb:
>
> > Hi,
>
> > I am using V5R4. Is there any way to see a table journal in the form
> > of SQL that was actually run on it? Can I see that at some date and
> > some time, someone did an UPDATE, or INSERT or DELETE? Can I see the
> > full SQL query that was executed (sort of like what is saved with
> > interactive SQL sessions, but for all users)?
>
> > The output of DSPJRN is very criptic, I'm looking for something
> > simpler.

Thanks everyone for replying! I'm looking into your suggestions.

0
10/11/2007 2:04:56 PM
simun.selak@gmail.com wrote:
> Hi,
> 
> I am using V5R4. Is there any way to see a table journal in the form
> of SQL that was actually run on it? Can I see that at some date and
> some time, someone did an UPDATE, or INSERT or DELETE? Can I see the
> full SQL query that was executed (sort of like what is saved with
> interactive SQL sessions, but for all users)?
> 
> The output of DSPJRN is very criptic, I'm looking for something
> simpler.

It's not clear if you're trying to track SQL statements or the results 
of running those SQL statements.

AFAIK, the possible SQL statements would come from tracking SQL through 
the database monitor, as has been noted by others.

The journal has little connection to actual SQL statements. The journal 
is used to track changes to data. Since changes (adding records, 
deleting records, changing records) can happen in many ways other than 
SQL, SQL statements are logged through a separate mechanism. The journal 
focuses more on the data rather than the means.

The journal entries can be cryptic until they're understood. The meaning 
of each of the fields can take some learning and experience. The big 
field at the end -- JOESD -- can look cryptic because it contains the 
data from the record that was changed, but it doesn't contain any 
descriptions of that data.

I've put a relatively simple tool up on my web site that can help with 
learning about viewing many journaled entries. It's a CL program and 
command, both named DSPJRNACT, plus a couple SQL statements -- one that 
runs via RUNSQLSTM and one that's used as a QM query statement.

http://home.earthlink.net/~tliotta/Files/Display_Journal_Activity/

You can download the source for those, upload and compile them on your 
System i and experiment. The process of viewing journal entries isn't 
really that difficult; all it takes is a little CL to get it done. 
Studying how and why this tool works should help you get a better 
background in using your journals.

It should work for most physical files. I haven't tried it with files 
with variable length fields and a few other less common field 
attributes. I suspect it could be modified to handle almost any 
variation if needed.

Once this simple tool works for you, a more complex and sophisticated 
tool might be more useful. (I've never needed one.) This tool should 
compile and run on most older systems and doesn't require the compilers 
to create it. It's distributed as source so you'll see how it works.

-- 
Tom Liotta
http://zap.to/tl400
0
thomas8368 (114)
10/15/2007 6:10:15 AM
Reply:

Similar Artilces:

Printing on AS400 via IBM AS400 Java Toolkit
Hello all, I'm working on a program that needs to send a print job to a printer connected to an AS/400. I've tried using the SpooledFileOutputStream and I've also tried using one of the SCS Writer classes. Neither solution is working. With the SpooledFileOutputStream I am at least able to create my print file, but when my program ends, the file is still not being printed. This program does not run on the AS400, it runs on a PC and connects to the AS400 via the toolkit classes. I know this part works as I am able to use the toolkit to access Data Queues, Files and Data Areas without a problem. Is there anyplace anyone can point me to see some examples of how to print a file using the AS400 Java Toolkit? Thanks in advance, Chuck Chuck, What printer data stream is used? or how was the printer data generated? I am wondering if the data stream being generated matches the data stream of the printer connected to the iSeries? What printer is attached to the iSeries and how is it configured? The iSeries info center has some Toolbox examples: Programming>Java>IBM Toolbox for Java>IBM Toolbox for Java Classes> Access Classes>Print>Creating... Dave Chuck wrote: > Hello all, > > I'm working on a program that needs to send a print job to a printer > connected to an AS/400. I've tried using the SpooledFileOutputStream > and I've also tried using one of the SCS Writer classes. Neither > solution is working. With the Sp...

AS400 to AS400 connection
Hi. What`s the rocommended method of copyting data beetween two AS400 (both on V5R1) ? Regards, Tom tom wrote: > Hi. > What`s the rocommended method of copyting data beetween two AS400 (both on > V5R1) ? Probably FTP. "tom" <tomeks@comp.pl> wrote in message news:c8c9u5$fb4$1@nemesis.news.tpi.pl... > Hi. > What`s the rocommended method of copyting data beetween two AS400 (both on > V5R1) ? > > Regards, > Tom > > It depends how often you are doing the copying & how much there is. If you want say one record but every 3 seconds then you can either store them up for a few hours days or weeks & use FTP, snads or a tape. Or you can do it realtime & use DDMF to zap each record to the other machine as its written. I actually save the data I want sending this way into a file which is read & deleted by a daemon style of job so that if comms or the other machine fails only the daemon is affected. FTP has its upside in that the target is easily resettable for say a unix machine but SNADS has an easy to use & understand message sent to the sender & recipient to verify arrival of the data. -- Jonathan Bailey. You could install the No Charge SW "Object Connect" from the OS CDs. Once setup you can issue cmds line SAVRSTLIB and SAVRSTOBJ. Give these cmds the LIB or OBJ list and the target system. It then saves/transfers/restores to the target system all with just the 1 SAVRSTxxx cmd. tom wro...

Microsoft uses IBM AS400's for development.
Not well known but Microsoft uses IBM AS400 machines with the Windows server card option to develop programs. This option is really a PC on a card but offers significant advantages over a stand alone pc in that it can support virtual sessions of Windows each of which can be rebooted as required without bringing down the other seesions or worse the rest of the machine. Microsoft is a huge IBM AS400 customer. Most people assume developers are using PC's sitting next to their work space. Fadl Ullah Jonnalagadda wrote: > Not well known but Microsoft uses IBM AS400 machines with the Windows > server card option to develop programs. This option is really a PC on > a card but offers significant advantages over a stand alone pc in that > it can support virtual sessions of Windows each of which can be > rebooted as required without bringing down the other seesions or worse > the rest of the machine. Microsoft is a huge IBM AS400 customer. Most > people assume developers are using PC's sitting next to their work > space. MS developers are using Win 2k3 and Win 2k8 servers as development machines too and not PC(s), with VMware. Fadl Ullah Jonnalagadda wrote: Plonk "Fadl Ullah Jonnalagadda" <fadlullah.jonnalagadda@gmail.com> wrote in message news:60deb8d3-5599-48d8-8667-6734e37a756b@31g2000vbf.googlegroups.com... > Not well known but Microsoft uses IBM AS400 machines with the Windows > server card option to develop programs. ...

* use in As400
I have been using as400 for agbout a month at work and i cannot figure out what the * means..... I understand wild card astericks perfectly like dir *.txt. However what does it mean before a word... the best I can figure out is that it means any... as in *DEV, *LIB. But what about *YES, *NO, etc.... Is there a good explanation or is it just an "AS400 thing" as a co-worker told me. Hi - On 10 Nov 2006 23:08:11 -0800, "greggiefen" <greggieFEN@gmail.com> wrote: >Is there a good explanation or is it just an "AS400 thing" as a >co-worker told me. It's just an OS/400 thing (actually it predates OS/400 back to CPF on the S/38) as a way to specify special values. For some things it could go either way. If a parameter only accepts a yes/no value, *YES/*NO or YES/NO or Y/N would work equally well. But for something like an object name, *ALL and ALL are _not_ the same thing. *ALL is all objects. ALL is an object called ALL. -- Ken http://www.kensims.net/ Opinions expressed are my own and do not necessarily represent the views of my employer or anyone in their right mind. Greg, The * in front of a parameter is a way to designate a reserved keyword without actually using up a real word. So, for example *YES is a reserved keyword but YES is not reserved. Many operating systems have reserved words that prohibit their use elsewhere. The AS/400 mitigates this by putting a * in front of the actual word to create a completel...

AS400 to AS400 data transfer
Hi I need to place a trigger on a set of tables on an AS400 to fire off whenever new records are added to these tables. This trigger program will then transfer the data to another AS400 across a WAN. This will allow us to transfer orders from one system to another. Can anyone tell me how I would achieve this. Normally if it had been a PC I would have used an ODBC type application but I am not sure what is available to me for AS400 to AS400 data transfer. I know that we can transfer a SAVF by FTP but this is not a route I would like to go down. I would prefer to populate tables directly if possible. Thanks for any help offered Iain Iain wrote: > Hi > > I need to place a trigger on a set of tables on an AS400 to fire off > whenever new records are added to these tables. This trigger program > will then transfer the data to another AS400 across a WAN. This will > allow us to transfer orders from one system to another. Even if there may be multiple way, I think the best would be using a remote journal, on the target system a journal entry exit program will be evoked at event time, so it can apply new records to the target tables, then it can fire a new event if necessary. -- Dr.Ugo Gagliardelli,Modena,ItalyCertifiedUindoscrasherA�ejoAlcoolInside Spaccamaroni andate a cagare/Spammers not welcome/Spammers v�o � merda Spamers iros a la mierda/Spamers allez vous faire foutre/Spammers loop schijten/Spammers macht Euch vom Acker/Spamerzy wypierdalac' ...

Why use an AS400?
I work with a company that really pushes the AS/400. My big question is why? What does the AS/400 offer that you can't get on a conventional server? I know our code is written in RPG and uses a SQL database. Any input would be apprecaited. Thank you for your help. There are 4 main reasons 1. Reliability - almost never goes down. 2. Security - no known virus. 3. Usually, a lower TCO (total cost of ownership) 4. Keep the investment in existing code (who else runs RPG?) Numbers 1 & 2 are why you see most casinos, banks, insurance companies, and the like running this system. Lee wrote: > I work with a company that really pushes the AS/400. My big question > is why? What does the AS/400 offer that you can't get on a > conventional server? I know our code is written in RPG and uses a SQL > database. > > Any input would be apprecaited. Thank you for your help. Maybe the question should be, what would you rather do? On Mon, 24 Mar 2008 05:39:53 -0700 (PDT), Lee wrote: >I work with a company that really pushes the AS/400. My big question >is why? What does the AS/400 offer that you can't get on a >conventional server? I know our code is written in RPG and uses a SQL >database. Why not? I mean write on a paper *all* the things you (or your company) do with the black box (the most important to me are): - identity management - terminal server (not windows style) - development framework - application server (not in th...

AS400 to AS400 connection issues
Hi All, We have two AS400's at different locations, and were able to passthrough and send files between both no problems. Last week one of our AS400's was moved to another location, with an IP change. We have updated the IP addresses on the other AS400 and can passthrough fine....however we can no longer send files from the new location. When I look at the distribution queue I see the following status: RTY-FAIL Any idea's as to what may be causing this? Thanks, Mike mot98@yahoo.com wrote: > Hi All, > > We have two AS400's at different locations, and were able to > passthrough and send files between both no problems. > > Last week one of our AS400's was moved to another location, with an IP > change. > > We have updated the IP addresses on the other AS400 and can passthrough > fine....however we can no longer send files from the new location. > > When I look at the distribution queue I see the following status: > RTY-FAIL > > Any idea's as to what may be causing this? run the CFGDSTSRV command and then look at all the menu options. Another command to look at is CFGTCP. -Steve Steve Richter wrote: > mot98@yahoo.com wrote: > > Hi All, > > > > We have two AS400's at different locations, and were able to > > passthrough and send files between both no problems. > > > > Last week one of our AS400's was moved to another location, with an IP > > chan...

IBM AS400
Does anyone have some notes, documentation or helful pointers about navigating, command language and DB2 on an AS400 for a guy who has done HP3000, Windows 2k/2k3, MS SQL, HP9000, IBM ES9000/UNIX, SCO UNIX? Ideally a commands cross reference qaulivalent would be terrific - I.E. HP3000 to AS400. Thanks much. P.S. I'm taking a role in a shop that runs its ERP system on this platform. Jim. ____________________________________________________________________________________ Get easy, one-click access to your favorites. Make Yahoo! your homepage. http://www.y...

As400 Journaling
Hi there I'm pretty new to AS400,I want to learn about journaling, how they work and how to set them up, also in the comming months we may be going high availability, linking into a second box offsite, can any of you share info on either of the above or let me know where I can find information on both. Keep up the good work. F Information is in the Backup and Recovery Guide, which is under the Systems Management path in the Information Center (go to http://as400bks.rochester.ibm.com and follow links). May also be some information in the Database topics. "Finny" <finnyo@hotmail.com> wrote in message news:a0e34e70.0401270224.792779c4@posting.google.com... > Hi there > I'm pretty new to AS400,I want to learn about journaling, how they > work and how to set them up, also in the comming months we may be > going high availability, linking into a second box offsite, can any of > you share info on either of the above or let me know where I can find > information on both. > Keep up the good work. > F ...

AS400 to AS400 data transfer #2
Hi I need to place a trigger on a set of tables on an AS400 to fire off whenever new records are added to these tables. This trigger program will then transfer the data to another AS400 across a WAN. This will allow us to transfer orders from one system to another. Can anyone tell me how I would achieve this. Normally if it had been a PC I would have used an ODBC type application but I am not sure what is available to me for AS400 to AS400 data transfer. I know that we can transfer a SAVF by FTP but this is not a route I would like to go down. I would prefer to populate tables directly if possible. We are using 2 model 820's with OS400 V5 R2 Thanks for any help offered Iain ...

Migrating to a new system which uses AS400. Sites which have useful info?
Our company is in the process of installing a new ERP system called Frontier made by Friedman which runs on an AS400. We have a small I.T department and at present none of us have any AS400 / OS400 experience. What sites have good technical information that can be downloaded (preferably for free) regarding system admin of the iSeries hardware and software. On another topic as anyone here got personal experience of Frontier and what do they think of it? Cheers. There are a number of good books available. Check both: http://www.mcpressonline.com/ http://www.pentontech.com/education/ Check iSeries Network for an iSeries specific site: http://www.iseriesnetwork.com/ Sorry, never heard of Frontier. Sam "Nexus" <nexus@nospam.com> wrote in message news:ASScf.8047$c66.5600@newsfe3-gui.ntli.net... > Our company is in the process of installing a new ERP system called > Frontier made by Friedman which runs on an AS400. > > We have a small I.T department and at present none of us have any AS400 / > OS400 experience. > > What sites have good technical information that can be downloaded > (preferably for free) regarding system admin of the iSeries hardware and > software. > > On another topic as anyone here got personal experience of Frontier and > what do they think of it? > > Cheers. > Nexus - Frontier is very strong for volume custom configured products such as doors, windows, blinds and ...

Buying used AS400
In 2001 I lost my job as an RPG/COBOL programmer of several years and ended up with jobs in the last 6 years that were not involved with AS400 at all. So now as a consultant of a few months have a client that needs data migrated off of their AS400 that had no PC's attached and have to work on getting a workstation set up with emulation card to download the data. As a result of this, I have decided to look into buying a used AS400 that I can used to download client data from tape as well as have RPG & QUERY400 compilers as a part of it. I think I need to look for a 170 or 270 but not sure what the difference between the 2 is? And I have found alot of places to buy the CPU with the OS but where do I find the other software to install on it. Also, has anyone had any experience in using the Nlynx 3xtwin PCI card to connect and download data using PCSupoort? Thanks MP 1st a home i5 (AS/400) is expensive to maintain. It's not just the hardware but the software licenses and hardware upkeep. I have had to barter for replacement features several time to keep my machine alive. 2nd to deal with client tapes you need compatible drives. Since there are so many formats this too can get expensive. I have had to FTP some very large files around because of not having the right tape drive. This may not be a problem if you have the kind of bandwidth I have. 3rd no one uses a PC emulation card anymore. Just setup your home network to work with iSeries Access via TC...

AS400 for Home Use
Hi all, I've been considering picking up a used as/400 and would appreciate any comments on the feasibility of purchasing a low end machine for development use at home. I have a background in rpg/cobol development but am unsure of hardware, processor and licensing issues involved. There seem to be many 170s and older interactive boxes with V4R4 available but can anyone comment on licensing, the availability of PDM, compilers and other LPPs in the used marketplace, etc? V4R4 with RPG, Cobol, etc would satisfy my initial requirements, but upgradeability to V5R1 with WDStudio tools would be an eventual concern. I would appreciate any advice on the minimum processor, memory requirements for any WAS development, webfacing etc for a single user in a non production environment. Thanks in advance. Allan Smallest current model is 800, but that's probably still a little too pricey for at home. You might be able to pick up a used 250. Either way, software has to be licensed from IBM. Another option is Baby/400, from California Software. I've never seen or used it, but they have a long history. (First product of theirs I heard of was Baby/36.) It runs on a PC, so hardware is inexpensive. It includes editor (like SEU), compilers, and database that mimics PF/LFs. If you only need to do some development and testing, this might be enough. But it is not OS/400. I'm pretty sure it won't have support for OS functions such as communications (SNA, TCP/IP), security, and...

From a AS400 with a CCSID to another AS400 with different CCSID
Hi all, I've the following issue: - I have to move data from a AS400 with CCSID 65535 (no conversion) to another AS400 with CCSID 37 I'm using DDM files on the second AS400 linked to the first AS400, but reading DDM files I have the problem that data are different in the special characters... So I changed my job session CCSID to 65535 with CHGJOB; with that I can see correctly DDM files data, but not the local files... What do you suggest to do? Many thanks in advance. Fabrizio On 09-Jun-2011 05:47 , Fabrizio wrote: > > I've the following issue: > > - I have to move data from a AS400 with CCSID 65535 (no conversion) > to another AS400 with CCSID 37 > > I'm using DDM files on the second AS400 linked to the first AS400, > but reading DDM files I have the problem that data are different in > the special characters... > > So I changed my job session CCSID to 65535 with CHGJOB; with that I > can see correctly DDM files data, but not the local files... > > What do you suggest to do? > The system CCSID QCCSID is effectively moot in that scenario as far as I can recall. What do matter are the CCSID of the job opening the file and then reading the data, and the CCSID of the columns of the file being opened. When the job is set to a proper CCSID, then whenever the data is also "tagged" properly with a CCSID [e.g. column of a table with a non-hex (non-65535) CCSID], the database will convert the dat...

Upload to AS400 using VB
I've got a little program written in VBA, which takes some data from an Excel file and uploads to a physical file on our AS400. The program works fine, except that the user is obliged to complete the login screen in order to carry out the upload request. I thus amended the prompt properties and hardcoded the id and password into the code. As far as I can tell this works, and I'm logged into the sytem as should be, but now I get the following error, when running the final "upload" method. "A conversion error has occurred during the tretament of the transfer demand". The only differnce between my program working and not working is this lack of user id/ password prompt. Anbody have any thoughts on why this is occurring? Note that the error I've displayed is a translation from French, since I am using French software. Thanks Mohsen Maybe it's your auditors blocking the hard coding of the password. -- Doug "mo_in_france" <qureshi.mohsen@gmail.com> wrote in message news:fca54c4e-6968-4a14-a5bd-389dbd592d3a@w34g2000hsg.googlegroups.com... > I've got a little program written in VBA, which takes some data from > an Excel file and uploads to a physical file on our AS400. > > The program works fine, except that the user is obliged to complete > the login screen in order to carry out the upload request. I thus > amended the prompt properties and hardcoded the id and password into > the code. As far a...

how to use and as400 9401-150
hello i just go and as400 ibm server model 9401-150 without instructions. and i dont understand how do you connect to it. some people tell me i need and 100 serial to twinax cable in a ibm page that i dont recall says that i can connect using the MI port on the back. but i am not sure how can i connect to this ports. was thinging if any of you guys can point me to and manual for this server as in the ibm page i cannot find the instruction manual and what programs do i need to connect to it. and thanks for ur help guys. There are basically 3 ways to connect. 1. With twinax cable to a "dumb" 5250 terminal (if twinax card installed) 2. With a special serial cable to a PC with special software installed (console) 3. With ethernet to a PC with 5250 emulation installed. Prob the most common, but does not support "console" mode, and requires TCP services be running. Maybe the 150 has other options? I'm not very familiar with that model. The IBM infocenter web site might help. http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp Change the V5R4 to the version of the o/s you have. the as400 has in the back 2 cards installed 1 that have like 2 printer ports that are flat and on that have 1 of those connector and a serial conector. also it have 2 more serial conector one that says MI (management Interface) and another one that says UPS(uniterruptible power suppy) also idk what os this is running as this was a gift so its there a way i can ...

using AS400 SMTP server
I'm trying to use the SMTP server from our AS400, which has outbound access= to the internet but is blocked from inbound ports. The purpose is to have our custom AS400 software email customer invoices, s= tatements, and ocasional reports. I've added an SFP TXT record to the DNS and that seems to be accepted as a = "pass" by many servers. However certain servers like aol.com and rcn.com w= ill not accept email from us. The reason given is usually some kind of tim= eout that doesn't give the reason that the server won't accept email from u= s: NOT ABLE TO DELIVER MAIL TO SOME/ALL RECIPIENTS. REPLY CODES WITH FIRST DIGIT =3D '4' OR '5' ARE ERROR REPLIES. ERRORS THAT DO NOT HAVE ERROR REPLY CODES MAY EXIST. HOST PNNK00 NOT ABLE TO DELIVER MAIL TO FOLLOWING RECIPIENT(S): <xxxxxxx@yyyyyyy.NET> RETRIES EXHAUSTED WHILE ATTEMPTING TO CONNECT TO REMOTE HOST yyyyyyyy. In looking into this more, I see that while we now have an SPF that seems O= K, we don't have domain keys, DKIM or sender id Does anyone know the best way to get an AS400 internal SMTP server to be tr= usted where the AS400 is being used for Send Only and not open to public in= ternet pings on any port? Thanks Can't you bounce/relay it off a real internal SMTP server rather than trying to let the AS/400 do the sending ? The mail server framework has always been fraught with issues and it may be better to bou...

A basic question about AS400 using
Bonjour, (1) What is the link between AS400 and iSeries? Sorry, I didn't understand that on the IBM site. (2) A collegue told me that an AS400 was used by a customer for transmitting IP datagrams (coming from a LAN) on a X.25 dedicated line. I don't understand why an application server has been used for that translation. For me, IP and X.25 protocols are just level 1, 2, 3 services. Am I wrong? Can somebody give me a few words? Thanks, Angelot (1) iSeries is just a "rebranding" (ie renaming) of the AS400 under the larger eServer family of IBM servers. (2) It is doubtful the AS400 is being used just to "translate IP datagrams on an X.25 dedicated line". There must be some other application the AS400 is being used for. "Angelot" <NoSpam@NoSpam.fr> wrote in message news:c0tvrp$pto$1@news-reader4.wanadoo.fr... > Bonjour, > > (1) What is the link between AS400 and iSeries? Sorry, I didn't understand > that on the IBM site. > > > (2) A collegue told me that an AS400 was used by a customer for transmitting > IP datagrams (coming from a LAN) on a X.25 dedicated line. > I don't understand why an application server has been used for that > translation. For me, IP and X.25 protocols are just level 1, 2, 3 services. > Am I wrong? > > Can somebody give me a few words? > Thanks, > Angelot > > Thanks Jim for these remarks. Regards ...

Position with company using AS400
I'm currently representing a company that is running on AS400 and they're using BPCS for their ERP system. They're looking for someone to come in and head up their IT management. The position is a direct staff position in Milwaukee, WI. Please let me know your thoughts on that. Thanks, Dan Nischke Director of IT Business Development dnischke@sitepersonnel.com (262) 345-9933 x200 ...

How do set Journal size in AS400?
Dear all, How do set the Journal size in AS400?. I am a beginner in AS400? If anybody knows Pls share with me. Veera > How to set journal size? It is more appropriately the 'Journal Receiver' size Threshold; a size which specifies when [at what threshold] warnings of and actions, should be made to establish a new receiver to be attached to the journal. The CRTJRNRCV command establishes that. Either CRTJRN or CHGJRN to attach a journal to that receiver. Both of the latter commands allow setting Size Options and Management features for the receivers. Regards, Chuck -- All comments provided "as is" with no warranties of any kind whatsoever and may not represent positions, strategies, nor views of my employer ...

link table IBM AS400
Hi. Sorry for my english but I have MS Access in italian. My problem is by link a table from IBM As400 (with > 100.000 rows). The output of the table is many #ELIMINATO (in english "delete" / "erase".. I dont't know the exact message). I have tried with "requery" or recreating the link without results. If I *import* the table from AS400 it works perfectly without problems. Here an abstract txt BOLAZI;BOLCLI;BOLDBO;BOLNBO;BOLCAU;BOLNPR;BOLTRE;BOLMAT;BOLDES [........] [........] ;;;;;;;#Eliminato;#Eliminato ;;;;;;;#Eliminato;#Eliminato ;;;;;;;#Eliminato;#Eliminato 0;474;990204;354;10;1;1; 936;PC Intel Pentium II 400 Miditower 0;474;990204;354;10;4;1; 1890;CD-ROM drive 36X 0;474;990204;354;10;5;1; 1692;HD-SCSI 4.5 Gb IBM Ultrastar WIDE 7200 0;474;990204;354;10;6;1; 1497;HD-SCSI 9.1 Gb IBM DDRS-39130 UWIDE [........] Thanks in advance M. "Mire" <mary@hotmail.com> wrote in message news:buo9eo$k39dq$1@ID-57790.news.uni-berlin.de... > Hi. > Sorry for my english but I have MS Access in italian. > My problem is by link a table from IBM As400 (with > 100.000 rows). > > The output of the table is many #ELIMINATO (in english "delete" / "erase".. > I dont't know the exact message). > I have tried with "requery" or recreating the link without results. > > If I *import* the table from AS400 it works perfectly without problems. > &...

connect to AS400 using ADO...
Can someonne please tell me an ADO connection string to use to link an AS400 table to Access WITHOUT using a DSN? Thanks. Matthew Wells MWells@FirstByte.net Matthew Wells wrote: > Can someonne please tell me an ADO connection string to use to link an AS400 > table to Access WITHOUT using a DSN? > > Thanks. > > Matthew Wells > MWells@FirstByte.net Have a look at Carl Prothman's website. He has examples of ADO/.NET connections on his website http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForAS400FromIBM Matthew Wells wrote: > Can someonne please tell me an ADO connection string to use to link > an AS400 table to Access WITHOUT using a DSN? > > Thanks. > > Matthew Wells > MWells@FirstByte.net I don't know about ADO specifically, but I have never been able to do any sort of connection to our AS400 (ISeries) without using a DSN. The problem I run into is that I can find no entry in the connect string for the "System" argument that works, and yet it also doesn't work if I leave that argument out. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com I've been able to open an ADO connection without a DSN, but not refresh a table link. "Rick Brandt" <rickbrandt2@hotmail.com> wrote in message news:Zkz5e.8887$c76.8335@newssvr11.news.prodigy.com... > Matthew Wells wrote: > > Can s...

PowerPC extensions for IBM AS400
Looking for an explanation or documentation on the as400 specific extensions to the PowerPC instruction set. Pointers on the as400 are stored as 16 byte values. The LQ ( load quad word ) and STQ ( store quad word ) instructions are used to load and store those pointers. Here is PPC assembler code that loads a pointer from an EA into a register: LQ 24, 0x1e50(30), 6 SELRI 26, 25, 0, 41 LQ loads the 16 bytes stored at EA reg30 + 0x1e50 into reg24 and reg25. The next SELRI stmt does something to reg25 and places the result in reg26. Does anyone know what the 3rd opera...

Printing to as400 using cups
Hi all, Has anyone been able to print to an as/400 from linux using cups? If so, what format did you use for the name, location, and device uri? I'm using: name: nameofprinter location: //nameofas400 device: 'windows printer via SAMBA' device uri: smb://Workgroup/nameofas400/nameofprinteronas400 Problem is, this doesn't work and I think my "device uri" is wrong, but don't know what to change it to. Using the old linux box, I added this to my printcap and it worked (still does actually): nameofprinter:\ :sd=/var/spool/lpd/nameofprinter:\ :rm=amoroso3:\ :rp=QUSRSYS/nameofprinter:\ :lp=/dev/null:\ :sh: -- Julien Mills Amoroso's Baking Company Tel: (215) 471-4740 IS Dept email: julien@amorosobaking.com www.amorosobaking.com I'm not sure why you'd do this - almost everyone use tcp/ip attached printers with as400 now, so why wouldn't you just go directly to the printer itself? julien mills wrote: > Hi all, > > Has anyone been able to print to an as/400 from linux using > cups? > If so, what format did you use for the name, location, > and device uri? > > I'm using: > > name: nameofprinter > location: //nameofas400 > device: 'windows printer via SAMBA' > device uri: smb://Workgroup/nameofas400/nameofprinteronas400 &g...

Web resources about - How to use AS400 journaling? - comp.sys.ibm.as400.misc

Journaling file system - Wikipedia, the free encyclopedia
If a crash occurs between steps 1 and 2, there will be an orphaned inode and hence a storage leak . On the other hand, if only step 2 is performed ...

Heyday — Automatic Journaling on the App Store on iTunes
Get Heyday — Automatic Journaling on the App Store. See screenshots and ratings, and read customer reviews.

Day One 2 upgrades the journaling experience for both Mac and iOS
The team at Bloom Built has today released the latest version of its journaling app Day One. Five since its original debut, with 40 free releases ...

Search And Tagging Features Finally Written Into Popular Journaling App Day One
Day One — the popular journaling app that we here at AppAdvice has been devoted to since, well, day one — has just received a significant update. ...

Apple's journaling system for iOS makes geotagging a system-wide feature
Apple's journaling system for iOS makes geotagging a system-wide feature

Price Drop: Zentries: The Art of Journaling
Zentries: The Art of Journaling 1.0 Device: iOS iPad Only Category: Productivity Price: Free, Version: 1.0 ( iTunes ) Description: Zentries ...

Two of My Favorite Things: Bullet Journaling and Some Lines a Day Journaling
... planners or journals and are giving it a try. For those who are still on the fence, or those who haven't quite found their favorite journaling ...


Kate Hudson believes in journaling, eating 5 meals a day & indulging
... like, once a week where I’m not thinking about it. I want to indulge! I want to do things that are not necessarily healthy sometimes.” Journaling: ...

Day One’s New Publish Feature Turns A Great Journaling App Into A Sleek Sharing Tool
Day One has been one of the most popular journaling apps in the App Store for years, and it has always stuck to its guns: privately storing your ...

Resources last updated: 3/24/2016 12:44:06 PM