Get answers.  Share knowledge.  Collaborate with peers.




CL/400
I need to copy records from work link to our database file, so I am using CPYFRMIMPF command in the following way CPYFRMIMPF FROMSTMF(&LINK) TOFILE(SRINSOFT/EDI850WK) + MBROPT(*REPLACE) RCDDLM(*CRLF) + DTAFMT(*DLM) STRDLM(‘”‘) FLDDLM(‘,’) + FROMRCD(2 *END) My worklink has 5 records but it copies only the 2nd and 4th record to my database file. What is [...]

Answer Question   |  January 21, 2013  12:00 PM
CL command, CPYFRMIMPF
asked by:
105 pts.

Problem with the READ from PF in RPGLE
Hi ! Im trying to read a physical file from my RPGLE program. That physical file having many fileds. AGCDE is the one of the filed there. The AGCDE data is from 001 to 700. But i just added it randomly. Now im having a problem with READ in RPGLE.. When i call the program [...]

Answer Question   |  January 18, 2013  6:47 AM
AS400 RPGLE, reading Physical file
asked by:
1,485 pts.

Networking Problem
PLEASE PLEASE HELP. I recently started working for a company where currently their network structure is this- Dedicated Server, Windows Server 2008. They have a modem connected to a wifi router. therefore it’s a LAN to WAN structure. A couple of the computers are connected via their LAN cables and a few connect through WIFI. [...]

Answer Question   |  January 17, 2013  11:44 PM
LAN to WAN Connectivity
asked by:
15 pts.

Deleting IFS files
Would anyone be able to help me with the following code? I modified it to delete entries in a folder older that 35 days from today’s date when the program is run. Thanks in advance for any assistance you can offer. PGM DCL &TODAY *CHAR 6 DCL &TODAY2 *CHAR 6 DCL &MBRDATE *CHAR 10 ADDLIBLE [...]

Answer Question   |  January 17, 2013  7:37 PM
IFS, IFS Folder
asked by:
145 pts.

Job log spool file of a running job
Can I create a spool file of the job log of a currently running job on the system?

Answer Question   |  January 17, 2013  6:32 PM
OS/400, OS/400 spool file
asked by:
145 pts.

Linking tables in databases that change each month
The test software that we use, creates a new database each month. So you have to relink the tables you use to the newly named database each month to get the new information. Is there some code that I can put into my database that will go out and relink these tables?

Answer Question   |  January 17, 2013  5:42 PM
Microsoft Access 2007, Microsoft Access database
asked by:
5 pts.

RPGILE
Declare one character field value is 2.77 in this filed length is 15 data type Char i covert the value to numeric using %dec function. But i am getting the value like 277 it does not display dot. how to get dot ?

Answer Question   |  January 17, 2013  5:24 PM
Buildin Funtion
asked by:
105 pts.

how to stop execution of a code until a Jwindow is closed?
Hi this might be tuff to understand- what i m trying to do is i m creating an object of a JWindow class into another class… like this:- public class GamePlay extends JPanel{ TossWindow toss; public GamePlay(){ Toss(); } public void Toss(){ toss=new TossWindow(team1Name,team2Name); System.out.println(toss.tossWinner); } } in above code TossWindow is a class that [...]

Answer Question   |  January 17, 2013  4:41 PM
Class, Inheritance, Java, JWindow, object, Swing, Threading
asked by:
425 pts.

How to implement MOUBTN using RPG III/RPG400
We are converting some code in a legacy application and, in its simplest form, want to know that a mouse has been used/clicked rather than ENTER pressed. We are not that familiar with the MOUBTN keyword, which we assume will tell us what we want, and are having trouble getting this to work. Though we’ve [...]

Answer Question   |  January 17, 2013  2:58 PM
AS/400, DSPF, MOUBTN, Mouse, RPG III, RPG/400
asked by:
250 pts.

Expression to insert value to a table column in SQL
My CL program has RUNSQLSTM. The SQL source has some SQL statements(source is of type SQL) which inserts value to a file. I need to change the SQL to have a column(FLD1) value like this (A*B*C)/10**D. A,B,C, and D are file fields. The attributes are like this A- (15,2) B- 13 C – (13,5) D [...]

Answer Question   |  January 17, 2013  10:11 AM
AS/400, SQL
asked by:
1,975 pts.

How to create backup RAID configuration?
Hello everybody. I am studying about Hard RAID. I want to backup RAID configuration and save it to my USB or FDD, so how to do it? Is RAID configuration only in RAID card?

Answer Question   |  January 17, 2013  9:37 AM
RAID, RAID configuration
asked by:
5 pts.

Telecommunication
What is BTS and BAC in telecommunication transmission?

Answer Question   |  January 17, 2013  9:15 AM
BAC, BTS, Telecommunications
asked by:
5 pts.

SQLRPGLE- Query Not fetching records in program
Hi I have below query in my program , when i executed it interactively thro strsql , its fetching records but the same query is not fetching records when i execute it in my program. Please provide your valuable answers as soon as possible.. as i need it very urgently… As si mentioned it has [...]

Answer Question   |  January 17, 2013  7:28 AM
AS/400, i series, IBM, SQLRPGLE
asked by:
95 pts.

Excel Menu Bar disappeared
How do I get the Excel Menu Bar back. I add it through the VB Editor, but once I closed and relaunched Excel, the menu bar disappeared again. I was told to search for *.xlb file, but could not find any! Please help.

Answer Question   |  January 17, 2013  3:23 AM
Microsoft Excel, microsoft excel functions
asked by:
5 pts.

How can I copy an order or quote
How do you copy an order or quote to save time?

Answer Question   |  January 17, 2013  3:18 AM
Purchase order
asked by:
10 pts.

UserProfiles in AS/400
Hi Group, I am unable to access my UserProfile, I checked the status its in “ENABLED” state. What could be done to access it. What are the reasons for the UserProfile in AS/400 being disabled. Regards, MVRK

Answer Question   |  January 17, 2013  12:17 AM
AS/400, AS/400 administration, OS/400
asked by:
340 pts.

Computers
How do I photocopy information about computers from newspapers

Answer Question   |  January 17, 2013  11:53 PM
Photoshop
asked by:
10 pts.

moving file from ifs into qgpl
How is this accomplished ? thx.

Answer Question   |  January 16, 2013  8:30 PM
IFS Directory to iSeries Folder
asked by:
20 pts.

What’s your top IT priority for 2013?
In TechTarget’s annual IT Priorities Survey of IT managers, data protection was #1 on respondents’ list with over 56%. Server virtualization and network-based security take the next 2 spots. Do you agree with this list? If not, what’s your top IT priority for 2013?

Answer Question   |  February 5, 2013  8:30 PM
Data protection, IT, Server virtualization
asked by:
11,410 pts.

Antivirus software
Is it not recommended to have more than 1 anti virus software? On your computer, and if it’s not, why? & why would you want to go out & install your own anti virus when more all the carriers (Comcast, AT&T, Clear, etc.) supply it with their product. Or to flip the script so to [...]

Answer Question   |  January 17, 2013  8:25 PM
Antivirus, Antivirus software
asked by:
20 pts.