Hello, We have VeriSign certificates installed to allow for SSL connectivity to Telnet, the Database…etc. Problem is that I need to be able to track who’s using SSL to connect to the database on port 9471 and output it to a file. Any ideas on how to go about finding this information. I cannot just…

Hello We hava been able to produce the SQL that returns us a Vertical table with the LABELTEXT  from table CLIENTES (sql against qsys2/syscolumns).   SELECT LABELTEXT FROM QSYS2.SYSCOLUMNS WHERE TABLE_NAME = ‘CLIENTES’ AND TABLE_SCHEMA = ‘MANEL’ Observe vertical orientation. Column 1 Column 2 xhrname Name xhrsurname   Last Name Now I would like to join this…

I want to develop a TSQL query. First I need to determine if all the numbers in one of the fields are in numerical order and also find the missing holes in the number sequence. Secondly I need to sort by another field and by a particular criteria.  The words that I need to sort-by…

Dear Friends, We are in a plan of migrating system to some other technology like Java/.NET etc. Please find the details and questions below. Information about the current System: Synon (CA -2E) 8.5 Version Few modules the source is getting generated in COBOL and other in RPG Database we using DB2/400 Questions: What all should…

For a Synon generated display file, how do you get the + sign or the ‘More’ to not show when there are no more records to display in subfile?

Hello All,  I’m trying to execute a fetch into DS on a SQL statement and keep getting code 30: Number of host variables less than result values. The DS and SELECT statement both have the same number of values as far as I can see.  Here’s the DS and select fields code: D ClaimRecDS    …

Hello everyone, Is there a way to strip non-numeric characters from a char column? Example: I have a Clients file, with column “Telephone Number” (CLPhone, 20, A). The thing is, phone number for many clients is filled with different formats. Example1: (123-12345) Example2: 123 12345 Example3: 123/12345 And even worse . Is there a way to select…

query to find n’th Highest salary in a file?

How to create a SQL VIEW of the file to present packed or binary values as characters? I know we can create an sql view using CREATE VIEW library/view1 AS SELECT * FROM library/filename.  But can anyone tell me how to present packed or binary values as characters using this? I used the command cast but…

Our VB.net person is using OLE DB Provider IBMDA400 to connect to our ISeries (AS/400). He uses a Table adapter to do Inserts, Deletes, etc… to files on the ISeries (AS/400). For some reason the QZDASOINIT job that is used keeps the files he works with open, doesn’t close them. Can he close them or…

I have 2 files that are clones – created by DUPOBJ. File_A is the original. File_BU is the copy. After I finish processing File_A, I want to update the same column (tSTAdm) in File_A when it is not equal to the same column (tStAdm) in File_BU. The file has a unique key – TsStat. I got the…

I want to send an email every friday evening at 4PM for reminding them to fill the time sheet…. Please help me out in this how to do this…

How do you copy substring from clob-field with SQL if substring from/to positions are varables? This works OK (RPG free w embedded sql): exec sql select substr(myclobfield, 25, 70)                 INTO :mystring                 FROM MYLIB/MYFILE; [/pre] Whereas this causes a compilation error: from = 25; to    = 70; exec sql select substr(myclobfield, :from, :to)                …

How can I Only select updates/deletes/changes to files and dont want  I/O type access  using query

I’m wanting to write script(s) where multiple (V6R1)LPAR’s will have different SBS’s brought down, ROBOT, JDE applications brought down, and SQL packages deleted. Once verified all brought down cleanly, another script(s) will bring them all back up on their perspective LPAR’s cleanly. Of course I will be notified of any issues where recycle isn’t working correctly……

Hi I need to Run a Job daily at 11Am Except Saturday & Sunday. How I can do it. And also What is the Use of WRKJOBSCDE and ADDJOBSCDE. Lib1/Prog1  user-user1    

  Why is this so diffcult to space so it is readable? FILE01 has some records that need to be copied to FILE02 and deleted from FILE01. This is my error: *RNF7260 30 3 The Factor 2 operand is not valid for the specified operation.  What do I need to fix? FFILE01    UF   F 2300       …

how do i show the password field as some symbols like(*****)..i tried it…but it shows only blank….

How to create 6 digit non repeating random number in rpgle as400?

how to use PULDWN option in display file.. what s the use of PULDWN…