tag:blogger.com,1999:blog-34020393.post1266738535690853272..comments2024-03-27T10:59:38.307-07:00Comments on Jim's PeopleSoft Journal: Productivity gains through Meta-SQLJim Marionhttp://www.blogger.com/profile/12995110203807924786noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-34020393.post-781186491913044752021-02-16T21:27:08.960-08:002021-02-16T21:27:08.960-08:00@Mohit, what file format are you trying to create?...@Mohit, what file format are you trying to create? A data mover output file is not easy, but a CSV or XML is trivial. Yes, you can write to a file using your exact code. Just use &file.WriteLine("string to write"); assuming &file represents your open file.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-11123405995626055022021-01-29T04:23:27.482-08:002021-01-29T04:23:27.482-08:00Hi Jim -
I am trying to write insert script in f...Hi Jim - <br /><br />I am trying to write insert script in file through peoplecode, how we can do that<br />or how we can create .dat file through peoplecode<br /><br />like <br />&SQL = CreateSQL("%SelectAll(:1) where", &Recname)<br />while &sql.fetch(&recname)<br />---- write into file all the fielvalues<br />end-whileMohithttps://www.blogger.com/profile/13440812071342307116noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-53517067286538600562018-11-15T21:30:26.068-08:002018-11-15T21:30:26.068-08:00@Kevin, look for &SQL1.Execute();@Kevin, look for &SQL1.Execute();Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-5789500454943796392018-07-05T12:08:10.557-07:002018-07-05T12:08:10.557-07:00Hi Jim - I realize this post is quite old but bein...Hi Jim - I realize this post is quite old but being new to programming in App Engine and I found the information very helpful. One question, I'm trying to trace through an AppEngine program that utilizes PeopleCode and there is a declared variable within an OnExecute step with this usage "&SQL1 = CreateSQL("%Insert(:1)");" I'm trying to determine what is being populated (so that I can modify it hopefully) inside the (:1) variable. I've tried searching Record definitions for FUNCLIB but did not find what I felt was relevant. Any ideas how I can dig deeper to find this? Thanks again!kdrymerhttps://www.blogger.com/profile/17441665416082980058noreply@blogger.com