We do a 3 step process
1. retrieve a DIR
2.Read the DIR to determine what files to puul
3. Go back and rename the files that we pulled.

There is a command schtasks.exe that can create scheduled tasks for this purpose. Create a .bat file to make it as scheduled task…. After that, put the file for GPO. It is best to see here for MS ref
u can also use free 3rd party tool for the same.

I am very beginner in SQL. I know the Column name, how to find out the table name by using SQL

I have downloaded it from the mochasoft website. I am actually looking for a free emulator to practise CLLE and RPGLE at home. The one that I have downloaded had the AS400 IP address by default, still I am not able to connect. I am using windows 7 os, telnet was not active. I have activated telnet. Still same issue. Please can anyone help me ?

@ITKE , the above link is not working ?

You could load one row which says — no records exist
Or you could set the indicator for DSPSFL off, DSPSFLCTL on and exfmt the control this will show the headings with blank space were subfile would be.
Phil

Why don’t you try on cloud CRM software. It not only supports quick integration but also is very easy to implement.
Know more about CRMnext…
http://www.crmnext.com

Why don’t you try on cloud CRM software. It not only supports quick integration but also is very easy to implement.
Know more about CRMnext…
<a href=”www.crmnext.com”> CRM Software </a>
<a href=”http://www.crmnext.com/us/product/socialcrm.aspx”>Social CRM</a>

I did the above steps but its not working…
Example::
—————————————–
FLD1 FLD2 FLD3
AAA AAAA AAAAA
AAA AAAA AAAAA
AAA AAAA AAAAA

rrn = 3
—————————————–
BB ______ _________

There is no records having the value as BB..
now rrn = 0

in this case i need to display subfile with rrn = 0

Hi Tom,
I have completed some part of my program in which i fetched msgfile data to physical file through qmhrtvm now i want to search text in my physical file column in that column contained msg description.

…it was important to keep the records in the order I was reading them. I also needed to change the M to an N as I was copying the records over.

CPYF can keep the records in the same order. A single SQL UPDATE statement could change all of the “M” codes to “N”.

Tom

Due to my inability to get the spacing right, I didn’t include the subroutine. Yes, it did just move the 3 fields to the new fields.

I did end up just creating the new file that will hold the set of records that I needed. I couldn’t use the CPYF command as it was important to keep the records in the order I was reading them. I also needed to change the M to an N as I was copying the records over.

I am going to try the suggestions you gave me, so I can see if that solves the problem with program described files.

Thanks everyone!

I will try

How do I tell SQL Server 2005 to support more than one language for storing and retrieving data?

…windows 7 clients which are not communicating to a 2003 DC.

There appear to be various difficulties getting Win 7 clients properly connected to a Win 2003 domain. Review Windows 7 clients on 2003 domain / group policy and Windows Small Business Server 2003: Windows 7, Windows Vista and Outlook 2007 compatibility update for example areas to investigate.

Tom

…just do a CPYF command…

I’d suspect the subroutine MOVEREC simply moves the three input fields to the output fields. But without seeing the code, it’s just a guess.

…records with RECTYP = “H”

And do what with records with RECTYP = “N”?

Tom

I have downloaded as400 emulator TN5250 (free trial version).

It might help if you told us which TN5250 emulator you’re using.

Tom

Your EXCEPT lines are specifying a file name not a output exception name.
Try EXCEPT ADD.

Better yet delete this crappy pgm and just do a CPYF command and select only records with RECTYP = “H”

I have degraded one of the PCs to XP and it is communicating to DC. So it is the problem with windows 7 OS .Other 3 PCs are still having the problem. Can any body suggest?

Gigabit ethernet.

I agree with amigus.