CNX Corporation Support and Information Forums

vvOut_buffer error with high volumes

edward.thomas — Thu, 17 May 2012 10:38:22 GMT

The following piece of code works fine generating JSON without referencing an RPG field and so limiting the string size. Unfortunately when I get to about 20,000 records I get the following error:

To procedure . . . . . . . : VVOUT_DATA
Statement . . . . . . . . . : 26500
Pointer not set for location referenced.

followed by:

The call to VVOUT_BUFF ended in error

PHP Code:


vvOut_buffer('Content-type:text/json'

            +LF+LF+'{"products":'+OB:STARTBUFFER);



i =0;

setll *loval abc_pf;

read abc_pf;



dow not %eof (abc_pf) ;

   i += 1;

   descp =  %XLATE('''"': '``': descp);



   if i = 1;

       vvOut_buffer('{"PFLD":"' + %trim(pfld)

       + '","DFLD":"' + %trim(dfld) + '"}'+'');

   else;

       vvOut_buffer(',{"PFLD":"' + %trim(pfld)

       + '","DFLD":"' + %trim(dfld) + '"}'+'');

   endif;



   read abc_pf;

enddo;



vvOut_buffer(CB+CC:ENDBUFFER);

Any ideas why this might be happening?

Thanks

[HELPED] What Valence Folders Are/Are Not Affected By Valence Updates?

rkanemeier — Tue, 15 May 2012 20:10:04 GMT

I have already asked a similar question over the phone but wanted to make sure I understand the implications behind creating custom HTML/CSS/JS/MVC folders inside /valence-3.x. Does CNX recommend creating our own custom IFS folders to store custom code or should we create a new folder underneath the valence IFS folder? I "think" the MVC apps created by Nitro App Builder automatically store them inside the /valence-3.1 folder (with no option of choosing "where" to store them). If this is correct, then if we ever plan to use some sort of change management (Turnover in our case), we should probably create our custom folders inside of /valence-3.x since the MVC architecture is somewhat softcoded in DB2 files and requires references to the default Nitro App Builder folders.

Do I have the correct understanding?

[SOLVED] vvIn_array with numeric values

ktoole — Tue, 15 May 2012 15:53:27 GMT

I have an array defined as 6s 0 and I am trying to get data from a JSON array in to this structure. The values are all numbers. They appear in firebug as "DATA [152,1234,25410]". I load it with " numElements = vvIn_array( 'DATA':%addr(ticketArr)
:%size(ticketArr:*all):%size(ticketArr));" and I get data but the numbers are 152000, 123400, and 254100 instead of 152,1234, and 25410 as I need. Any ideas why?

[HELPED] Question about renderers

MCSchlemme — Tue, 15 May 2012 14:31:53 GMT

I know the parms for a renderer are as follows:

Code:

function renderName(value, metaData, record, rowIndex, colIndex, store)

Can I/how do I add an extra parm to the function, IE

Code:

function renderName(value, metaData, record, rowIndex, colIndex, store, type)

Typically the code looks like this and the parms passed are not listed.

Code:

renderer: this.renderUnitNumerics

Thanks...

Separate ext sources from valence environment

Siebe Vos — Tue, 15 May 2012 10:21:08 GMT

All Sencha ExtJs, Touch and FusionChart sources are stored on the IFS in the Valence 3.1 folder. The process for copying the IFS objects (manually or via instance manager) for these folders is very heavy since it contains thousands of files and takes more than an hour. Besides that this takes a lot of disk space for each created environment.

We placed all these folders outside in a specific folder outside the Valence folder adjusted the aias and the directory authorization in the Apache config, like /vvweb/include/ext-3.4.0, /vvweb/include/ext-4.0.7 etc. Now copying takes about one minute.

This request already has been brought in via mail

Custom styling without modifying the valence.css

Siebe Vos — Tue, 15 May 2012 10:06:39 GMT

Is it possible to apply a specific (css) styling to a Valence portal, without modifying the valence.css so it is clearer for users to see the difference between a test and production environment?

[SOLVED] Calling a method from within another method

MCSchlemme — Mon, 14 May 2012 19:17:33 GMT

Can I call a method from within another method?

I have both getColumns and getCompanyColumns defined in the HTML as follows:

When I used the commented code, the getColumns method works. When I try to call getCompanyColumns from within the getColumns, Chrome debugger tells me getCompanyColumns is not defined.

What's up?

Thanks...

Code:

var getColumns = function(columnName) {



            // Build columns dynamically based on parm.

                switch (columnName) {



                case 'Company':

                  var columns = getCompanyColumns();

                        //var columns = [{

                        //        header: "Level",

                        //        sortable: false,

                        //        width: 120,

                        //        align: 'left',

                        //        //dataIndex: 'M0001D1'

                        //  dataIndex: 'email'

                        //}];

                        break;

[HELPED] Instances

MCSchlemme — Thu, 10 May 2012 12:43:43 GMT

I'm not sure, however I think I can use instances for production/test. I'd like to develop with using a test instance and then migrate to using a production instance.

Is there some code I need to put in the .js file to point to a different instance?

An example would be helpful.

Thanks...

[SOLVED] SQL Prepare Failed - Keyword FETCH not expected

EvaY — Tue, 08 May 2012 20:36:36 GMT

Hey guys,

I'm trying to move a Valence 2.2 app to 3.1 and, other than recompiling the backend RPG over a Valence 3.1 library, I've done nothing to change it. It runs in 2.2 but when I try to run it in 3.1 I get the following error:

{"SUCCESS":"0","MSG":"ERROR OCCURED-SQL prepare failed (SQLSTT=42601) - SQL0199 - Keyword FETCH not expected. Valid tokens: FOR USE SKIP WAIT WITH OPTIMIZE."}

I'm using vvOut_execSqlToJson in a very simple backend RPG (with a ridiculous dynamic SQL statement):

Code:

 

wStmt ='Select a.YAAN8, a.YAALPH, Substring(a.YAHMCU,8,2) As CC, ' +             

             'b.ABALPH, c.JMDL01, d.MCDL01, Left(e.DRDL01,3) As SHIFT ' +

             'From PRODDTA/F060116 a ' +

             'Left Join PRODDTA/F0101 b On a.YAANPA = b.ABAN8 ' +

             'Left Join PRODDTA/F08001 c On a.YAJBCD = c.JMJBCD ' +

             'And a.YAJBST = c.JMJBST ' +

             'Left Join PRODDTA/F0006 d On ' +

             'Substring(a.YAHMCU,4,6)= Substring(d.MCMCU,7,6) ' +

             'Left Join PRODCTL/F0005 e On a.YASHFT = Substring(e.DRKY,10,1) ' +

             'And e.DRSY = '+SQ+ '06' +SQ+ ' And e.DRRT = ' +SQ+ 'SH' +SQ+

             ' Where a.YAPAST <> '+SQ+ 'T' +SQ;



       // Retrieve search field values from browser page

       vvOut.startFrom =vvIn_num('start');

       vvOut.maxResults=vvIn_num('limit');

       wSortField       =vvIn_char('sort');

       wName            =vvIn_char('name');

       wCost            =vvIn_char('cost');

       wTitle           =vvIn_char('title');

       wSupervisor      =vvIn_char('supervisor');





       wName = %xlate(lower:upper:wName);

       wTitle = %xlate(lower:upper:wTitle);

       wSupervisor = %xlate(lower:upper:wSupervisor);





       // Continue to build SQL stmt with search criteria (if any) from user

       If wName <> *blanks;

         wStmt+=' And Upper(a.YAALPH) Like '+SQ+'%'+%trim(wName)+'%'+SQ;

       Endif;





       If wCost <> *blanks;

         wStmt+=' And Substring(a.YAHMCU,8,2) Like '+SQ+'%'+%trim(wCost)+'%'+SQ;

       Endif;





       If wTitle <> *blanks;

         wStmt+=' And Upper(c.JMDL01) Like '+SQ+'%'+%trim(wTitle)+'%'+SQ;

       Endif;





       If wSupervisor <> *blanks;

         wStmt+=' And Upper(b.ABALPH) Like '+SQ+'%'+%trim(wSupervisor)+'%'+SQ;

       Endif;





        // Finish up SQL stmt and pass it to Valence service pgm for processing

       wSortDir=vvIn_char('dir');

       wStmt+=' Order By '+%trim(wSortField)+' '+%trim(wSortDir) +

             ' For Read Only';





       vvOut.rootName='grid1';

       vvOut_execSqlToJson(vvOut:wStmt);

I found another thread in the forum ["SQL question"] from 9/2011 that talks about vvOut_execSqlToJson and the intention to add code to the API in the next release that will append a FETCH clause to the SQL statement... wondering if that has anything to do with it. Any ideas?

Thanks!
Eva

[HELPED] UPDATE 20120431 : Library VALENCE on Iseries still needed ?

ThierryC — Tue, 08 May 2012 07:14:51 GMT

Hi,

yesterday, i performed the update 2012 04 31 on Valence31 and noticed that a new library 'VALENCE' has been created.

Can i remove this library : (i assume yes ?)

it contains :

Object Type Attrib
VALENCE0 *FILE SAVF
VVUPDATEA *FILE SAVF
VVUPDATEB *FILE SAVF
VVUPDATEC *FILE SAVF
VVUPDATED *FILE SAVF

also the VALENCE31 library contains 2 savf's i assume these can also be removed without any problems?

VVUPDIFS *FILE SAVF
VVUPDLIB *FILE SAVF

and how or where can check or verify the version i have on my system ?

Thx
Thierry

Training session idea

barnettc2 — Mon, 07 May 2012 20:53:01 GMT

I attended one of your training sessions recently. We spent a bit of time on debugging, but I almost think there should be a class devoted to it. A 1-2 day class going over the Chrome and Firefox debuggers, as well as other techniques used. A problem I had today was solved via the forum, just by changing which ext class I imported in. Tips such as this could really increase productivity. If not a class, maybe some webinar sessions would suffice.

[SOLVED] Render Date-Time Stamp in Grid

David — Mon, 07 May 2012 20:32:01 GMT

A Date-Time Stamp from AS400 comes in as Full Year-Month-Day-Hour.Minute.Seconds.Fraction Second.
Example '2012-05-07-15.55.14.123000'

How to display in (MVC) grid as example: 05 / 07 / 2012 15:55:14.123000

[SOLVED] MVC popup window from controller

barnettc2 — Mon, 07 May 2012 19:17:04 GMT

I have a window class

Code:

Ext.define('PurchaseOrder.view.AddPOWindow', {

        extend: 'Ext.window.Window',

        alias: 'widget.purchaseorderaddpowindow',

        ...

In my controller, from everything I've read, this should display my component:

Code:

fnNewPo: function() {

                //Open the add window

                var newAddWindow = Ext.widget('purchaseorderaddpowindow');

                //newAddWindow.show();

        },

It does nothing. if I un-comment the show(), it gives an error "cannot call method substring of undefined"

[HELPED] vvOut_SQLtoCSV

ktoole — Tue, 01 May 2012 14:01:01 GMT

I get an error stating "missing ) in parenthetical" with all my titles and data there, it just does not open the csv file in firefox. This is the spec for the vvOut data structure:

Code:

         vvOut.download = 'Y';

         vvOut.file     = 'flockSchedule.csv';

         vvOut.longSqlNames = 'Y';

         vvOut_execSqlToCSV(vvOut:stmt);

It appears the SQL statement is working fine, it just isn't completing the csv file process. All the data is showing up in debug in the response.

[SOLVED] Grid store reload

barnettc2 — Fri, 27 Apr 2012 18:19:26 GMT

Ok, this MVC is hurting my head. I have a grid, with an associated store. I have search fields, that should make the store reload the data and update the grid. I have a listener set up in my controller:

Code:

'#searchpo': {

                                specialkey: function(field, e) {

                                        if (e.getKey() === e.ENTER) {

                                                var searchPOValue = this.getPurchaseOrderGrid().down("#searchpo").getValue();

                                                var theGrid = this.getPurchaseOrderGrid();

                                                var theGridStore = theGrid.getStore();

                                                theGridStore.removeAll();

                                                theGridStore.proxy.extraParams = {searchpo: searchPOValue};

                                                theGridStore.load();

                                                Ext.Msg.alert('Sweet!', 'You searched for PO ' + searchPOValue);

                                        }

                                }

                        }

I get a 500 server error on the load().

I can provide more info if needed.