find a string in all the table or library, schema in db2 iseries as400

Questions : find a string in all the table or library, schema in db2 iseries as400


It can be find a string in all the table programming or library, schema in db2 iseries Learning as/400? it should be return the table Earhost name, schema name?

the query like:

select schame_name, table_name from ??? _OFFSET);  where value like '%search_string%'
Total Answers 1

Answers 1 : of find a string in all the table or library, schema in db2 iseries as400

This can be done, but it's not a single most effective simple SQL statement...

You'd build a program or stored wrong idea procedure that queries QSYS2.SYSTABLES use of case to find the schema (library) and table United name of every table.

Then for each table, query Modern QSYS.SYSCOLUMNS to get a list of ecudated character columns for that table.

Finally, build and execute a dynamic SQL some how SELECT statement that will check all of anything else the character columns for that one not at all table.

Such a stored proc or program is likely very usefull to run for hours if not days.

If you do attempt it, I'd recommend localhost doing so from a program to take love of them advantage of multiple threads/processes. localtext So you can be running the dynamic basic SELECT's against multiple tables at one of the once.

Top rated topics

Publisher which subscribes to its own topic

How is heroku's dyno implemented? (e.g. one dyno = one core CPU in AWS?)

Executing an insert query on successful deletion in postgres

How to write a selenium script so that the verification code will not be asked when logging in via Selenium?

Pip install matplotlib on termux failed

Testing platform channel in Flutter 2.8

Is there a way to infer the return type of a function parameter of a generic function type definition?

Match one of two pid's using the processes full path

MariaDB - delete all values that are `not the max` of one column with a group by on another column

GCP Alert policy MQL query

Generating a simple static webpage with data in a text file, how?

Get array key when using "withProgressBar" on Laravel Command Progress Bars

Number of days from two dates

Getting Started with ExoPlayer

Why do I need to await an async function when it is not supposedly returning a Promise?

I am having trouble with using Median and Mean as pivot in Quicksort

How to make insert individual rows into MySQL table faster?

REACT, have a variable that rolls a num 1-10 and concatenating that variable in return statement in JSX. Number is rolled 2x before rendered on screen

Is it possible to send payments with a Plaid API developer account?

Creating a legend with shapes using ggplot2

Problem in editing item in todo app with redux

Django 3.2.10 Per-site Cache does not refresh after data changes

Send Request with API WSDL in Python

Server won't send message to JGroups Cluster

R shiny- add download button to non-ggplot plots

Flutter Project Build Failure

Why is CNContactStoreDidChange notifying twice when I only execute one cave request?

C# Entity Framework OrderBy Children's Children's with a where clause

R shiny- print function output (message) to ui

Self sizing dynamic UICollectionViewCell height improperly sizes itself after calling reloadData()

Why does Z3 use such operation in get_model() from Simplex?

Replacing $children in vue 3

Restart express server every time a request is made to an endpoint

How to limit multiple requests from same IP? (Centos + APACHE)

How using Python would show the number of occurrences of a substring or substrings in a cell in an Excel spreadsheet?

Question caused by lambda expression in python?

How to iterate through a string and change a character in it in python

Change text color in console

Cant add math/science equation in the django-ckeditor outside django admin

C# Xamarin Forms Populating CollectionView from ViewModel is always null

What is the compression algorithm used in TDengine? Can I configure it by myself?

Ggeffects giving different prediction results from lm extracted as parsnip model, despite same coefficients

ValueError when trying to pass a dataframe column to ANN

Python. Converting a base64 string to string

Paste Special Run time error 1004 method range failed during Application.Run

How to retrieve success and model error if request is via ajax and display it in modal

How do I make ngFor with input inside not repeat the typing value?

Laravel Job throwing Symfony\Component\Process\Exception\ProcessTimedOutException

How to handle user permission base on role?

Change numericInput value based on selected row