IBM i Global

Latest Discussions

Omitting certain fields from a file using sql quer ...

By: jerry ven , 9 hours ago

Hi, Rather than selecting select field1,field2,... field99 from a file if i want to omit only certain fields and let the other fields be selected as it is so there any way for the same using select /omit criteria in sql query ? Thanks
RE: Files - fields queries

By: jerry ven , yesterday

Thank you all very much for all these inputs here. Thanks much..
RE: SQL Fetch into *AUTO Array Does Not Go to Next ...

By: David Taylor , yesterday

@ace ace , thanks for the input. I suspect once I have a true use case for this, I would use the loop to store or process a chunk at a time. ------------------------------ David Taylor Sr Application Developer Range Resources Fort Worth ------- ...

More

Latest Blogs

東京海上日動システムズ様　生成AI事例です。

By: MIKIO SASAKI 26 days ago

生成AIを活用して、詳細設計書をもとに命令文（プロンプト）を作り、プログラム・コードを生成することが可能です。実証実験の結果、プログラミング工程における既存アプリケーションの修正や新規アプリケーションの開発において、平均約40%、最大約90%の生産性向上私もチラっとwatsonx.ai試してみて、上記の生産性向上は無理なく実現できそうに思いました。現時点ですと新規アプリ作るより、既存アプリコード保守はより容易にできそうに思います。（個人的意見です。） https://jp ...
Independent Auxiliary Storage pool(IASP) on IBM i

By: Rohit Chauhan one month ago

IASP refers to Independent Auxiliary Storage pool. It is basically a collection of disk units which forms a separate storage pool which can be brought offline or online without impacting the system default storage or system ASP. Auxiliary storage is the ...

1 person likes this.
Limiting 5250 sessions by IP address?

By: Robert Berendt 2 months ago

Many of us know of the system value QLMTDEVSSN. You can read about it at https://www.ibm.com/docs/en/i/7.5?topic=values-limit-device-sessions-qlmtdevssn The original intent of that was to stop a user from sharing their logon credentials and having ...

2 people like this.
IBM Champion Spotlight: Nirmal Khatri

By: Namitha K 4 months ago

In the dynamic world of technology, Nirmal Khatri emerges as a passionate advocate for IBM i, leaving a persisting mark on the community. With a career spanning over 17 years in the IT industry, Nirmal's evolution from a Software Developer to an IBM i ...

3 people like this.
Sign up to meet and greet the next generation of IBM i experts!

By: Linda Alkire 8 months ago

Is your company looking fresh faces with IBM i experience? Sign up to attend a virtual meet and greet sponsored by the COMMON Education Foundation (CEF) on Thursday November 16, 2023 from 11:00AM - 12:30PM EDT What is it? This 1.5 hour event is ...