creating outfile in as400
6:04
5 ай бұрын
Using Open Query File (OPNQRYF)
16:24
CPF0000 vs CPF9999
8:24
6 ай бұрын
MONMSG
8:00
6 ай бұрын
WRKQRY tutorial for beginners
23:57
GET FTP command
5:47
6 ай бұрын
CD directory name FTP command
10:18
Пікірлер
@tahirm09
@tahirm09 19 күн бұрын
good
@tahirm09
@tahirm09 21 күн бұрын
Good
@higiniofuentes2551
@higiniofuentes2551 26 күн бұрын
An example of member and file would be interesting Thank you!
@higiniofuentes2551
@higiniofuentes2551 26 күн бұрын
Is me or in fixed rpg you have option update and in full free you have delete option? Thank you!
@higiniofuentes2551
@higiniofuentes2551 26 күн бұрын
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!
@usagirocks
@usagirocks 26 күн бұрын
Do the macros not record doubleclicking? Mine didnt seem to work.
@mathewk6932
@mathewk6932 29 күн бұрын
Can you Make video on json sql using more than 2 files joining them and complex json kind of...
@MartinWidmer_OGDeveloper
@MartinWidmer_OGDeveloper Ай бұрын
Poor audio quality, not clear what you are doing to compile... no explanation of the basics of RPG programming.
@AS400andSQLTricks
@AS400andSQLTricks Ай бұрын
Thanks for your feedback. I appreciate your suggestions.
@madhurao8053
@madhurao8053 Ай бұрын
good one...more lag...
@AS400andSQLTricks
@AS400andSQLTricks Ай бұрын
Ok, I will make sure to keep it in mind
@middebalu
@middebalu 2 ай бұрын
Can these macros be executed in the command line(cmd) when applications have already been opened?
@nilavan-y5j
@nilavan-y5j 2 ай бұрын
Packed (5,0) = +1234 What would be for -1234
@d-bozz1658
@d-bozz1658 2 ай бұрын
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.
@avijit616
@avijit616 2 ай бұрын
Sir, I want to know how stored procedures are created for the cobol db2 program. Please make some tutorial series on that.
@nishikantvayale9442
@nishikantvayale9442 2 ай бұрын
This is not correct... zoned 1 digit 1 byte, packed (n+1)/2 bytes...where n is total size
@cherylb8233
@cherylb8233 2 ай бұрын
Excellent ! Thank you
@WillRamos-b3k
@WillRamos-b3k 3 ай бұрын
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.
@NickLitten
@NickLitten 4 ай бұрын
*YES* by using SQL within the CL program, updating files is easy.
@dkravenprince2910
@dkravenprince2910 4 ай бұрын
Omg i was looking for a solution and this way can be used with charindex as well. You saved me.
@aishwaryaph524
@aishwaryaph524 4 ай бұрын
Thanks
@aalhadajitcanadalife3239
@aalhadajitcanadalife3239 4 ай бұрын
Hello. I am using PUB400 but I forgot my password on access client solutions.so how will I reset again?please help
@AS400andSQLTricks
@AS400andSQLTricks 3 ай бұрын
Visit www.pub400.com/ and you will see reset password link.
@sowjanyareddy7874
@sowjanyareddy7874 4 ай бұрын
Not clear bro
@AS400andSQLTricks
@AS400andSQLTricks 3 ай бұрын
Ok. will see
@VaraLakshmiKomarthi
@VaraLakshmiKomarthi 4 ай бұрын
How you handle this [ ] brackets, it's giving compile errors.
@AS400andSQLTricks
@AS400andSQLTricks 3 ай бұрын
you may copy paste it in source
@akshit9631
@akshit9631 5 ай бұрын
Thank you so much for the wonderful information... You saved me when I needed,,🙏🙏🙏🙏🙏
@munendrababup7653
@munendrababup7653 5 ай бұрын
Thank you so Much. very useful for me this video.
@dylancrespo4539
@dylancrespo4539 5 ай бұрын
Is there a way to see what SQL statements or a job is executing, or what stored procedure it is executing?
@aravindbadeti2599
@aravindbadeti2599 5 ай бұрын
Can you make videos on calling java programs from rpgle
@AS400andSQLTricks
@AS400andSQLTricks 5 ай бұрын
Ok
@enrome
@enrome 5 ай бұрын
Creating tutorials with a non-activated Windows... Pathetic.
@ViratxDoodle
@ViratxDoodle 5 ай бұрын
Hey, Why is your website not working?
@AS400andSQLTricks
@AS400andSQLTricks 5 ай бұрын
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.
@AS400andSQLTricks
@AS400andSQLTricks 5 ай бұрын
My website www.as400andsqltricks.com is accessible now.
@ViratxDoodle
@ViratxDoodle 5 ай бұрын
Thanks for the update, it's working indeed. :)
@tahirm09
@tahirm09 5 ай бұрын
good
@tahirm09
@tahirm09 6 ай бұрын
Good
@tahirm09
@tahirm09 6 ай бұрын
good
@mathewk6932
@mathewk6932 6 ай бұрын
Create video on WRKQRY
@AS400andSQLTricks
@AS400andSQLTricks 6 ай бұрын
kzbin.info/www/bejne/i5bRY2luhdyom68
@deepakpatidar7219
@deepakpatidar7219 6 ай бұрын
Good 👍
@tahirm09
@tahirm09 6 ай бұрын
Good
@tahirm09
@tahirm09 6 ай бұрын
good
@tahirm09
@tahirm09 6 ай бұрын
Good
@tahirm09
@tahirm09 6 ай бұрын
Excellent !!!
@tahirm09
@tahirm09 6 ай бұрын
good
@rafaeleduardomantillamarin8588
@rafaeleduardomantillamarin8588 6 ай бұрын
Thank you very much for these As400 tricks, interesting and useful!
@rockfighter9974
@rockfighter9974 6 ай бұрын
Thank you
@sachinvithubone4278
@sachinvithubone4278 7 ай бұрын
Good
@sachinvithubone4278
@sachinvithubone4278 7 ай бұрын
When we can use sflnxtchg can you let's know.
@AS400andSQLTricks
@AS400andSQLTricks 7 ай бұрын
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.
@ravikumars9697
@ravikumars9697 7 ай бұрын
Write code also
@AS400andSQLTricks
@AS400andSQLTricks 7 ай бұрын
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.
@SuryaMouni3394
@SuryaMouni3394 7 ай бұрын
Why we eval with PTR1: C 10? to get the DATA value
@AS400andSQLTricks
@AS400andSQLTricks 7 ай бұрын
data at the address that pointer variable holds
@sachinvithubone4278
@sachinvithubone4278 7 ай бұрын
Small question answered video gain the knowledge. Thank you
@AS400andSQLTricks
@AS400andSQLTricks 7 ай бұрын
Glad to hear it!
@shaiknizamuddin4415
@shaiknizamuddin4415 3 ай бұрын
​@@AS400andSQLTricks your shorts are very useful for so many people's like me
@firedancers1216
@firedancers1216 7 ай бұрын
Do we have any sftp related example, like how interface xml , json or csv files to sftp server thanks
@Drakula840
@Drakula840 7 ай бұрын
Is there any way to contact you
@AS400andSQLTricks
@AS400andSQLTricks 7 ай бұрын
Please ask your question here
@Drakula840
@Drakula840 7 ай бұрын
@@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
@Drakula840
@Drakula840 7 ай бұрын
@@AS400andSQLTricks please make a video on halt indicator
@deepabose
@deepabose Ай бұрын
How to run acs macros using cmd
@Drakula840
@Drakula840 7 ай бұрын
Thank you for the topic
@rajrani7873
@rajrani7873 7 ай бұрын
🎉🎉🎉
@rajrani7873
@rajrani7873 7 ай бұрын
👍🏻👍🏻👍🏻👍🏻✌🏻✌🏻☺️