Search found 23 matches

by eddie9394
Thu Jun 25, 2020 4:13 am
Forum: Questions & Answers
Topic: Heap size error when appending to Response.ContentString
Replies: 0
Views: 312

Heap size error when appending to Response.ContentString

Anyone know the limit on Response.ContentString? When the following server module executes, it generated an error on iSeries job and hangs. The client eventually timed out. And I have to end the job to clear it. This server module works fine if the result set is less then 25K rows ------------------...
by eddie9394
Fri Oct 25, 2019 4:07 am
Forum: Questions & Answers
Topic: How to deal with comma in description when using TRANSFORM_FILE to read CSV file?
Replies: 3
Views: 404

Re: How to deal with comma in description when using TRANSFORM_FILE to read CSV file?

Thanks for the help!

Yes, I did have double quotes around the description. Please refer to the uploaded screen snip.

You suggested something else is wrong, where should I start the search?! :idea: :?:
by eddie9394
Thu Oct 24, 2019 2:11 am
Forum: Questions & Answers
Topic: How to deal with comma in description when using TRANSFORM_FILE to read CSV file?
Replies: 3
Views: 404

How to deal with comma in description when using TRANSFORM_FILE to read CSV file?

I am using the TRANSFORM_FILE to read a CSV file into a list, it works fine most of the time, but when there is a comma in the description field, it will shift everything off, I try to double-quote the description field and it is not working. Is there any way to deal with this issue?
by eddie9394
Fri Oct 18, 2019 7:10 am
Forum: Questions & Answers
Topic: Server module returns error but everything seems fine in the log file (RESOLVED)
Replies: 3
Views: 656

Re: Server module returns error but everything seems fine in the log file

Thanks! Found the job log and noticed that the LANSA library was been removed from the CL so when the CL finish, the LDA clean-up was failing. Working perfectly now. Thanks for your help!
by eddie9394
Fri Oct 18, 2019 1:30 am
Forum: Questions & Answers
Topic: Server module returns error but everything seems fine in the log file (RESOLVED)
Replies: 3
Views: 656

Server module returns error but everything seems fine in the log file (RESOLVED)

From the web page, there is a button triggers the server module to create a CSV file on the AS400 and the page is waiting for the completed event to pull it up. The CSV file was created by the CL program and the log file shows that the execution completed normally. But it returns the following error...
by eddie9394
Wed Oct 02, 2019 5:37 am
Forum: Questions & Answers
Topic: DELETE from file with substring selection not working (RESOLVED)
Replies: 4
Views: 727

Re: DELETE from file with substring selection not working

Thank you! Got it to work with Select and Delete...... :D
by eddie9394
Tue Oct 01, 2019 2:12 am
Forum: Questions & Answers
Topic: DELETE from file with substring selection not working (RESOLVED)
Replies: 4
Views: 727

DELETE from file with substring selection not working (RESOLVED)

Delete From_File(CF1234) Where((#DTEDATE = #wk_date) *And (#DTRECTYP = "RC") *And (#DTCMR = "M") *And (#DTPCDE = *Blanks) *And (#DTDESC.Substring( 1 8 ) = "<*ERROR*")) Io_Error(*NEXT) The above statement is not working, I did a SQL delete it work Delete from cf1234 where dtedate=20191001 and DTRECTY...
by eddie9394
Tue Aug 13, 2019 12:55 am
Forum: Questions & Answers
Topic: Can I call a Stored Procedure on IBMi via SELECT_SQL and share a result set ?
Replies: 2
Views: 1258

Re: Can I call a Stored Procedure on IBMi via SELECT_SQL and share a result set ?

Any luck on getting the stored procedure call to work? I try to do the same thing but end up with the ultimate decimal 3 error. the SQL procedure works fine on both "SQL-Scripts" and "STRSQL".
by eddie9394
Thu Oct 18, 2018 2:52 am
Forum: Questions & Answers
Topic: User Name changed to DCXPGMLIB when Calling RPG
Replies: 2
Views: 1260

User Name changed to DCXPGMLIB when Calling RPG

I have a Server Module that create transaction records then call a function (to call a RPG program) to generate GL entries. Everything works fine except records generated by the RPG program are showing created by "DCXPGMLIB", the transaction records created before the function call in the same serve...
by eddie9394
Wed Oct 17, 2018 1:00 am
Forum: Questions & Answers
Topic: Insert return_rrn not working
Replies: 2
Views: 1105

Re: Insert return_rrn not working

yes, records are actually inserted in the table and the field is 15,0. I changed my logic to work around it. However, the Insert with RRN statement should work but it is not! :cry:

I have to use select_SQL using (Select RRN(<File>) from <File> ) to get the RRN
by eddie9394
Sat Oct 13, 2018 1:14 am
Forum: Questions & Answers
Topic: Insert return_rrn not working
Replies: 2
Views: 1105

Insert return_rrn not working

I use a insert with return_rrn() hopping to get the RRN of the inserted record, however i am getting the RRN of the first record with the same key. I had changed the SQL_table to allow duplicate keys and removed all the indexes, it is still not working right. Any idea? THANKS! selectlist named(#WRKL...
by eddie9394
Thu Oct 11, 2018 1:47 am
Forum: Questions & Answers
Topic: Using STM_File_Read / Transform_File to process Text file
Replies: 3
Views: 1173

Re: Using STM_File_Read / Transform_File to process Text file

Change the #WRKLIST entrys to *max, now the Transform_File works. Bad character issue remain unsolved!
by eddie9394
Thu Oct 11, 2018 1:04 am
Forum: Questions & Answers
Topic: Using STM_File_Read / Transform_File to process Text file
Replies: 3
Views: 1173

Re: Using STM_File_Read / Transform_File to process Text file

Mark, Thanks for the Reply! I try removing all the funny characters in the CSV file the STM_File_Read read all the records, but transform_file only read the first 50 records * Transform File use builtin(TRANSFORM_FILE) with_args(#WRKLIST #WK_String1 "OU") to_get(#RETNCODE) #wk_int6 := 0 selectlist n...
by eddie9394
Wed Oct 10, 2018 8:41 am
Forum: Questions & Answers
Topic: Using STM_File_Read / Transform_File to process Text file
Replies: 3
Views: 1173

Using STM_File_Read / Transform_File to process Text file

I am using the STM_FILE_Read / Transform_file to read the CSV file and create worklist. I had about 700+ records in the file and it stop at some record with bad data Cafe with the funny E. Any one know how to deal with funny character and force it to continue to read until the true EOF is reach? THA...
by eddie9394
Wed Oct 10, 2018 8:24 am
Forum: Questions & Answers
Topic: file picker and CSV file
Replies: 3
Views: 1511

Re: file picker and CSV file

I end up using BIF Transform_File, it work BUT it didn't process all the records in the CSV file because of funny character in the data content!

use builtin(TRANSFORM_FILE) with_args(#WRKLIST #FileName "O" "B") to_get(#RETNCODE)
by eddie9394
Wed Oct 10, 2018 12:26 am
Forum: Questions & Answers
Topic: file picker and CSV file
Replies: 3
Views: 1511

Re: file picker and CSV file

Thank you for the information! I will continue to play with it.
by eddie9394
Tue Oct 09, 2018 7:57 am
Forum: Questions & Answers
Topic: file picker and CSV file
Replies: 3
Views: 1511

file picker and CSV file

I am working on a project that will allow users to upload a CSV file from their local drive, the server module will save the CSV content to a database table and return a list. What is the best way to do this? When fooling around with the code, I ran into some interesting problem with the file picker...
by eddie9394
Wed Sep 26, 2018 5:07 am
Forum: Questions & Answers
Topic: Tab Order in Detail Command Window
Replies: 1
Views: 865

Tab Order in Detail Command Window

I have 5 input controls in the Detail Command Window, I set the Tab stop from 1 to 5, as I keep pressing the Tab key, it will keep counting up but will not loop back to the first one. Is there any property to set to make it loop back to the first one?
by eddie9394
Mon Sep 24, 2018 11:43 pm
Forum: Questions & Answers
Topic: Cannot read property 'mthREMOVEFIRST' of null
Replies: 6
Views: 2262

Re: Cannot read property 'mthREMOVEFIRST' of null

Yes, did it with a timer. THANKS for your support!
by eddie9394
Sat Sep 22, 2018 5:42 am
Forum: Questions & Answers
Topic: Cannot read property 'mthREMOVEFIRST' of null
Replies: 6
Views: 2262

Re: Cannot read property 'mthREMOVEFIRST' of null

Found my problem! The #COM_OWNER.avCloseForm have to be completely out of scope of the Save.Completed and the avExecuteAsyncOperation
:roll: :roll: :roll: