An example of member and file would be interesting Thank you!
@higiniofuentes255126 күн бұрын
Is me or in fixed rpg you have option update and in full free you have delete option? Thank you!
@higiniofuentes255126 күн бұрын
When you use rename is for the name of the record and not for the name of the file? What is the use of prefix(X), because in the video the sound is very bad? Thank you!
@usagirocks26 күн бұрын
Do the macros not record doubleclicking? Mine didnt seem to work.
@mathewk693229 күн бұрын
Can you Make video on json sql using more than 2 files joining them and complex json kind of...
@MartinWidmer_OGDeveloperАй бұрын
Poor audio quality, not clear what you are doing to compile... no explanation of the basics of RPG programming.
@AS400andSQLTricksАй бұрын
Thanks for your feedback. I appreciate your suggestions.
@madhurao8053Ай бұрын
good one...more lag...
@AS400andSQLTricksАй бұрын
Ok, I will make sure to keep it in mind
@middebalu2 ай бұрын
Can these macros be executed in the command line(cmd) when applications have already been opened?
@nilavan-y5j2 ай бұрын
Packed (5,0) = +1234 What would be for -1234
@d-bozz16582 ай бұрын
Thanks For the video! Just a question, there is some way to convert fields in wrkqry? For example I have a string field and I need to convert into numeric I tried using the define result fields option but no lucky.
@avijit6162 ай бұрын
Sir, I want to know how stored procedures are created for the cobol db2 program. Please make some tutorial series on that.
@nishikantvayale94422 ай бұрын
This is not correct... zoned 1 digit 1 byte, packed (n+1)/2 bytes...where n is total size
@cherylb82332 ай бұрын
Excellent ! Thank you
@WillRamos-b3k3 ай бұрын
Thank you for great example. This works great. Do you have video where you passing a json variable? When I do this the variable has ? trash. How can I get around this? Thanks.
@NickLitten4 ай бұрын
*YES* by using SQL within the CL program, updating files is easy.
@dkravenprince29104 ай бұрын
Omg i was looking for a solution and this way can be used with charindex as well. You saved me.
@aishwaryaph5244 ай бұрын
Thanks
@aalhadajitcanadalife32394 ай бұрын
Hello. I am using PUB400 but I forgot my password on access client solutions.so how will I reset again?please help
@AS400andSQLTricks3 ай бұрын
Visit www.pub400.com/ and you will see reset password link.
@sowjanyareddy78744 ай бұрын
Not clear bro
@AS400andSQLTricks3 ай бұрын
Ok. will see
@VaraLakshmiKomarthi4 ай бұрын
How you handle this [ ] brackets, it's giving compile errors.
@AS400andSQLTricks3 ай бұрын
you may copy paste it in source
@akshit96315 ай бұрын
Thank you so much for the wonderful information... You saved me when I needed,,🙏🙏🙏🙏🙏
@munendrababup76535 ай бұрын
Thank you so Much. very useful for me this video.
@dylancrespo45395 ай бұрын
Is there a way to see what SQL statements or a job is executing, or what stored procedure it is executing?
@aravindbadeti25995 ай бұрын
Can you make videos on calling java programs from rpgle
@AS400andSQLTricks5 ай бұрын
Ok
@enrome5 ай бұрын
Creating tutorials with a non-activated Windows... Pathetic.
@ViratxDoodle5 ай бұрын
Hey, Why is your website not working?
@AS400andSQLTricks5 ай бұрын
Yes. There is some issue in migration from Google domains to the squarespace. I did all the dns settings that were asked by the Google support but still it's not working. Please wait for sometime. I will probably find some solutions for this soon and will update everyone on this. The Google domains and squarespace migration deal becomes a blunder for my website. I wrote mail to the Squarespace support team and waited for their response. Thanks for asking. I will update u soon.
@AS400andSQLTricks5 ай бұрын
My website www.as400andsqltricks.com is accessible now.
@ViratxDoodle5 ай бұрын
Thanks for the update, it's working indeed. :)
@tahirm095 ай бұрын
good
@tahirm096 ай бұрын
Good
@tahirm096 ай бұрын
good
@mathewk69326 ай бұрын
Create video on WRKQRY
@AS400andSQLTricks6 ай бұрын
kzbin.info/www/bejne/i5bRY2luhdyom68
@deepakpatidar72196 ай бұрын
Good 👍
@tahirm096 ай бұрын
Good
@tahirm096 ай бұрын
good
@tahirm096 ай бұрын
Good
@tahirm096 ай бұрын
Excellent !!!
@tahirm096 ай бұрын
good
@rafaeleduardomantillamarin85886 ай бұрын
Thank you very much for these As400 tricks, interesting and useful!
@rockfighter99746 ай бұрын
Thank you
@sachinvithubone42787 ай бұрын
Good
@sachinvithubone42787 ай бұрын
When we can use sflnxtchg can you let's know.
@AS400andSQLTricks7 ай бұрын
If the SFLNXTCHG indicator on so in the subsequent processing the READC will get that changed record. Also the records can be updated for errors and if no errors are found then they can be processed. As the readc loop updates for errors it updates each subfile change record with the SFLNXTCHG indicator on and that allow the update loop to use the READC to get the records again.
@ravikumars96977 ай бұрын
Write code also
@AS400andSQLTricks7 ай бұрын
You may find long coding videos in my channel also. This is a short video to give a brief info. Thanks for watching my videos.
@SuryaMouni33947 ай бұрын
Why we eval with PTR1: C 10? to get the DATA value
@AS400andSQLTricks7 ай бұрын
data at the address that pointer variable holds
@sachinvithubone42787 ай бұрын
Small question answered video gain the knowledge. Thank you
@AS400andSQLTricks7 ай бұрын
Glad to hear it!
@shaiknizamuddin44153 ай бұрын
@@AS400andSQLTricks your shorts are very useful for so many people's like me
@firedancers12167 ай бұрын
Do we have any sftp related example, like how interface xml , json or csv files to sftp server thanks
@Drakula8407 ай бұрын
Is there any way to contact you
@AS400andSQLTricks7 ай бұрын
Please ask your question here
@Drakula8407 ай бұрын
@@AS400andSQLTricks macro can work on subfiles? I have tried on subfile project...it is not able select last record & this able to select only last page of first record but while we recording a macro..we select last record but while it's playing it's not selected it
@Drakula8407 ай бұрын
@@AS400andSQLTricks please make a video on halt indicator