tag:blogger.com,1999:blog-34020393.post3748722346860631039..comments2024-03-27T10:59:38.307-07:00Comments on Jim's PeopleSoft Journal: Creating Binary ArraysJim Marionhttp://www.blogger.com/profile/12995110203807924786noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-34020393.post-36091754614472733722022-06-23T05:45:01.995-07:002022-06-23T05:45:01.995-07:00Hi jb,
I was recently looking for something simil...Hi <a href="https://www.blogger.com/profile/17592234246746572388" rel="nofollow">jb</a>,<br><br><br /><br />I was recently looking for something similar. I wanted to do bitwise operations in PeopleCode but couldn't find anything on the web, so I set off on a quest to do some prototyping. With a little help from articles from <a href="https://www.blogger.com/profile/12995110203807924786" rel="nofollow">Jim Marion</a>, such as this one and <a href="https://blog.jsmpros.com/2008/09/calling-log4js-loggererror-from.html" rel="nofollow">this one</a>, I was able to pull it off using the bitwise methods in the java.math.BigInteger class. I've detailed how I did it here: <a href="https://peoplesoftrepublic.wordpress.com/2022/06/23/bitwise-operations-in-peoplecode" rel="nofollow">Bitwise Operations in PeopleCode</a>.hunkydorkyhttps://www.blogger.com/profile/03645106048294221575noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-74914269838039935252021-06-18T02:30:38.372-07:002021-06-18T02:30:38.372-07:00Hi Jim,
Is there any way to cast java byte array ...Hi Jim,<br /><br />Is there any way to cast java byte array (or base46 string) to PeopleSoft binary data type so that it can be written directly to %Response using WriteBinary.<br /><br />My requirement is to download a remote image file in IScript and serve it as attachment.<br />I know I can download the file, store it in database and query the binary data but I would like to do it without database.<br /><br />ThanksNilambarhttps://www.blogger.com/profile/11751648351546405768noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-78933846869045423452014-03-12T10:31:34.939-07:002014-03-12T10:31:34.939-07:00@jb, for bitwise operations? Java has operators fo...@jb, for bitwise operations? Java has operators for that. I am not sure about Java functions for this.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-21732687523510179922014-03-10T08:02:16.830-07:002014-03-10T08:02:16.830-07:00Jim, is there a way for me to interpret what bits ...Jim, is there a way for me to interpret what bits are set in binary field using PeopleCode? For example, if I have a binary field with a value of 33, bits 1 and 6 are 1, all others are 0. I can do this in SQL but I am looking for a simple Java function to use in PeopleCode. There doesn't appear to be a PC function...jbhttps://www.blogger.com/profile/17592234246746572388noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-11221569811463496552011-10-03T21:37:30.807-07:002011-10-03T21:37:30.807-07:00@trybowski, when you say SQL query, I assume you a...@trybowski, when you say SQL query, I assume you are referring to the SQL object or an SQLExec, not the PeopleSoft Query object. If this is the case, then, yes, getting column information for an SQL object or SQLExec is difficult. I'm not sure if it is even possible. If I were approaching this task, I would use PeopleSoft query to design my SQL and PeopleCode to get at the information. The PeopleCode API includes a query object that will give you all the meta-data you desire as well as the results. I used the Query API once for a "Favorite Queries" pagelet. The pagelet listed the user's favorite queries, and when clicked, would show the user the first 10 rows.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-54441513171651836522011-10-03T08:05:43.476-07:002011-10-03T08:05:43.476-07:00Hey Jim,
I am wondering if you know the solution t...Hey Jim,<br />I am wondering if you know the solution to the following case. I'd like to fetch column names from an SQL query (not tables, but query, including generated columns). I was thinking about using getMetaData() method, but here's a problem: how do I convert a PeopleSoft object, rowset, to java ResultSet? Or should I approach it differently? I wouldn't like to create any additional Java classes, a pure-peoplecode solution would be perfect.trybowskihttps://www.blogger.com/profile/03644758531276401176noreply@blogger.com