Search Results

Search: Posts Made By: Perlbaby
6,393
Posted By Perlbaby
Yes this works . How to transfer the print...
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...
6,393
Posted By Perlbaby
Have tried with below option but looks like i am...
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...
6,393
Posted By Perlbaby
Tab Delimiter to csv in python:perl
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 ...
12,337
Posted By Perlbaby
Split values using awk
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...
4,613
Posted By Perlbaby
Thanks Corona688 . I created a sub query and...
Thanks Corona688 . I created a sub query and called separately for those 2 columns and it worked . Thank you for suggestion :-) Cheers
4,613
Posted By Perlbaby
Hi Corona688...
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...
4,613
Posted By Perlbaby
DB2 Query modification to remove duplicate values using LISTAGG function
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 ;
...
Forum: Programming 12-04-2018
1,884
Posted By Perlbaby
DB2 z/os How to Track table delete Activities
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...
Forum: Programming 12-04-2018
3,197
Posted By Perlbaby
How to track table status delete/update/insert status in DB2 V10 z/os?
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...
Forum: Programming 08-28-2018
2,003
Posted By Perlbaby
Hello @durden_tyler Superb !! This works...
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 .
Forum: Programming 08-23-2018
2,003
Posted By Perlbaby
Hello Peasant. Thanks for the reply. But...
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...
Forum: Programming 08-22-2018
2,003
Posted By Perlbaby
Dear Robin 1. This is just learning exercise ...
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...
Forum: Programming 08-21-2018
2,003
Posted By Perlbaby
DB2 Query to pick hierarchy values
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"...
Forum: Programming 08-14-2018
1,113
Posted By Perlbaby
DB Query for Pivot
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 ...
Forum: Programming 08-03-2018
1,146
Posted By Perlbaby
Hello @jgt . Thanks for the response . Fair...
Hello @jgt . Thanks for the response . Fair answer - i wish you were my boss :-)
Forum: Programming 08-02-2018
1,146
Posted By Perlbaby
DB2 - Determine Cost Savings in USD - After performance Tuning
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...
Forum: Programming 06-06-2018
1,299
Posted By Perlbaby
Hi Robin First Thing : Thank you for looking...
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...
Forum: Programming 06-04-2018
1,299
Posted By Perlbaby
DB2 - Performance Issue using MERGE option
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 ...
Forum: Programming 05-28-2018
58,187
Posted By Perlbaby
Hi durden_tyler Tanks a lot . Works fine
Hi durden_tyler
Tanks a lot . Works fine
Forum: Programming 05-03-2018
58,187
Posted By Perlbaby
DB2 convert digits to binary format
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 (...
Forum: Programming 02-20-2018
1,039
Posted By Perlbaby
Embarcadero Rapid SQL query for dependency
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...
Forum: Programming 02-20-2018
7,903
Posted By Perlbaby
Hi Rudi . Thank you for the reply. Please find 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...
Forum: Programming 02-10-2018
7,903
Posted By Perlbaby
DB2 Query -Convert multi values from column to rows
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 :...
2,529
Posted By Perlbaby
Thanks RudiC and Don for reply . Just...
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 -...
2,529
Posted By Perlbaby
Python Script to take file count and insert into DB2 table
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...
Showing results 1 to 25 of 85

 
All times are GMT -4. The time now is 06:07 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy