Search Results

Yes this works .
How to transfer the print output to another path or file Ex : /tmp/new_file
I tried using echo , but if i run the code multiple times , the results are getting appended with...

Have tried with below option but looks like i am missing something as multiple lines are not getting picked as per expected format in thread

#!/bin/sh
set -f # unquoted $f3
IFS='[\t]'
while...

Hi
How do we handle delimiter values in python or perl to convert the field values from 3 columns to 2 columns into csv file

Columns Values

Product : Contain one value
ID : Ignore this ...

Hi Team
I am looking for easiest way in python or perl to convert the field values from two columns
The file contains Name,Company Worked(Separated by ; between each fields. It can have multiple...

Thanks Corona688 . I created a sub query and called separately for those 2 columns and it worked . Thank you for suggestion :-) Cheers

Hi Corona688 (https://www.unix.com/member_modal.php?u=43551&modal=1) Thank you for quick help on this . However I would need further info on the handling scenarios when we have multiple column in a...

I am using DB2 v9 and trying to get country values in comma seperated format using below query

SELECT distinct LISTAGG(COUNTRIES, ',') WITHIN GROUP(ORDER BY EMPLOYEE)
FROM LOCATION ;
...

Dear Team
I am using DB2 v10 z/os database . Need expert guidance to figure out best way to track table activities ( Ex Delete, Insert,Update )
Scenario
We have a table which is critical and...

Dear Team
I am using DB2 v10 z/os database . Need expert guidance to figure out best way to track table activities ( Ex Delete, Insert,Update )
Scenario



We have a table which is...

Hello @durden_tyler
Superb !! This works perfectly in db2 v10. I like the way you elaborated - crystal clear walkthrough for this scenario handling. Thanks again for your patience .

Hello Peasant.
Thanks for the reply.
But the expectation is different. If the person contains both roles say manager and interviewer. It should show only one record with manager. Please see...

Dear Robin
1. This is just learning exercise
2. I did try to rank option but looking for better approach
3. Looking for other option
4.Windows 10, DB2 v9
5.NA
Well I ranked based on roles...

Dear Team

I am using DB2 v9 .
I have a condition to check roles based on hierarchies like below example.

1.Ramesh has Roles as "Manager" and "Interviewer"
2.KITS has Roles as "Interviewer"...

hi team


With below results in Db2 v10.5 . Please refer column A and B are same,while Staus column defers with distinct values .


A B STATUS
Insert Update ...

Hello @jgt . Thanks for the response . Fair answer - i wish you were my boss :-)

Dear Team

Have this interesting question on how to determine cost savings(USD) based on performance tuning in Db2

I am using DB2 v10.5 . I worked on db2 procedure that loaded 20Million...

Hi Robin
First Thing : Thank you for looking into it and providing valid suggestions.

Made few changes :
1.I have removed distinct in the select query.
2.I already have indexes for both...

Dear Team,
I am using DB2 v10.5 and trying to load huge data using MERGE option ( 10-12 Million) using below query. Basically it loads data from staging to target . Staging table ...

Hi durden_tyler
Tanks a lot . Works fine

Dear Team

We use DB2 v10.5 and using DBArtisan tool

Can someone please guide how to convert digits to binary numbers using db2 feature.
Ex> for number 9 , binary should be 1001 (...

Team

I am using Embarcadero Rapid SQL V8 . When we right click on any procedure/table/view and open the contents. It has dependencies tab, which tell what all are the dependents used .

My...

Hi Rudi . Thank you for the reply. Please find my answers

1.database tables modified or inserted using : DB artisan / Rapid sql
2.output files to be operated upon : Within same tool . Can be...

Hi Team

I am using DB2 artisan tool and struck to handle multi values present in columns that are comma(,) separated. I want to convert those column values in separate rows .

For example :...

Thanks RudiC and Don for reply .

Just trying to make it more precise for better understanding ( Dropping the insert idea into DB2 tables )
1.you want the number of lines in each selected file -...

Team

I have files in different directories . How can i take the count of latest file and insert into Db2 table .
I am using
awk 'END{print NR+1-ARGC}' (File name)
to get the counts.
How...