defaria.com/blogs/Status/2005/01/ecrdesc.html

   1 <!DOCTYPE html>
   2 <html lang="en-us" itemscope itemtype="http://schema.org/Article">
   3   <head>
   4     <meta charset="utf-8">
   5     <meta name="description" content="Well I played around with this a little more and came up with a Perl script that will dump ECR descriptions fairly easy. From what I understand that's mostly what we want access to from a Linux box (though I...">
   6     <meta name="generator" content="Movable Type 5.2.3">
   7     <title>ecrdesc - Status</title>
   8     <link rel="alternate" type="application/atom+xml" title="Recent Entries" href="http://defaria.com/blogs/Status/atom.xml">
   9     <link rel="canonical" href="http://defaria.com/blogs/Status/2005/01/ecrdesc.html">
  10     <meta name="viewport" content="width=device-width,initial-scale=1">
  11     <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles.css">
  12     <!--[if lt IE 9]>
  13     <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles_ie.css">
  14     <script src="/mt/mt-static/support/theme_static/rainier/js/html5shiv.js"></script>
  15     <![endif]-->
  16
  17     <link rel="start" href="http://defaria.com/blogs/Status/">
  18
  19     <link rel="prev" href="http://defaria.com/blogs/Status/2005/01/files4ecr.html" title="Files4ecr">
  20     <link rel="next" href="http://defaria.com/blogs/Status/2005/01/tot-build-succe.html" title="TOT Build succeeds">
  21     <!-- Open Graph Protocol -->
  22     <meta property="og:type" content="article">
  23     <meta property="og:locale" content="en-us">
  24     <meta property="og:title" content="ecrdesc">
  25     <meta property="og:url" content="http://defaria.com/blogs/Status/2005/01/ecrdesc.html">
  26     <meta property="og:description" content="Well I played around with this a little more and came up with a Perl script that will dump ECR descriptions fairly easy. From what I understand that's mostly what we want access to from a Linux box (though I...">
  27     <meta property="og:site_name" content="Status">
  28     <meta property="og:image" content="/mt/mt-static/support/theme_static/rainier/img/siteicon-sample.png">
  29     <!-- Metadata -->
  30     <meta itemprop="description" content="Well I played around with this a little more and came up with a Perl script that will dump ECR descriptions fairly easy. From what I understand that's mostly what we want access to from a Linux box (though I...">
  31     <link itemprop="url" href="http://defaria.com/blogs/Status/2005/01/ecrdesc.html">
  32     <link itemprop="image" href="/mt/mt-static/support/theme_static/rainier/img/siteicon-sample.png">
  33
  34   </head>
  35   <body>
  36     <div id="container">
  37       <div id="container-inner">
  38         <header id="header" role="banner">
  39           <div id="header-inner">
  40             <div id="header-content">
  41               <h1>
  42                 <a href="http://defaria.com/blogs/Status/">
  43
  44                   Status
  45
  46                 </a>
  47               </h1>
  48
  49             </div>
  50
  51             <nav role="navigation">
  52           <ul>
  53             <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
  54
  55
  56           </ul>
  57         </nav>
  58
  59           </div>
  60         </header>
  61         <div id="content">
  62           <div id="content-inner">
  63             <ul class="breadcrumb breadcrumb-list">
  64               <li class="breadcrumb-list-item"><a href="http://defaria.com/blogs/Status/">Home</a></li>
  65               <li class="breadcrumb-list-item">ecrdesc</li>
  66             </ul>
  67             <div id="individual-main" class="main" role="main">
  68               <article id="entry-1547" class="entry entry-asset asset hentry">
  69                 <div class="asset-header">
  70                   <h2 itemprop="name" class="asset-name entry-title">ecrdesc</h2>
  71                   <footer class="asset-meta">
  72                     <ul class="asset-meta-list">
  73                       <li class="asset-meta-list-item">Posted on <time datetime="2005-01-07T16:03:05-08:00" itemprop="datePublished">January  7, 2005</time></li>
  74                       <li class="asset-meta-list-item">by <span class="author entry-author vcard"></span></li>
  75
  76
  77                       <li class="asset-meta-list-item">in <a itemprop="articleSection" rel="tag" href="http://defaria.com/blogs/Status/lynuxworks/">LynuxWorks</a></li>
  78
  79
  80                    </ul>
  81                 </footer>
  82                 </div>
  83                 <div class="entry-content asset-content" itemprop="articleBody">
  84                   <p>Well I played around with this a little more and came up with a Perl script that will dump ECR descriptions fairly easy. From what I understand that's mostly what we want access to from a Linux box (though I could envision wanting other things perhaps in the future). The problem as I see it is that this script will only run on lynx12. It should be runnable from any machine really however you would need to install the DBD module for Informix for Perl access. Unfortunately this requires at least an Informix Client SDK and that's not free!  :-(</p>
  85                   <p>Here's the simple script (currently at lynx12:/tmp/ecrdesc.pl):</p>
  86
  87 <div class="code"><pre>
  88 #!/usr/bin/perl
  89 ################################################################################
  90 #
  91 # File:         ecrdesc
  92 # Description:  This script will dump out the description for the ECR #(s)
  93 #               passed in.
  94 # Author:       Andrew@DeFaria.com
  95 # Created:      Fri Jan  7 15:35:13 PST 2005
  96 # Language:     Perl
  97 #
  98 # (c) Copyright 2005, LynxWorks Inc., all rights reserved
  99 #
 100 ################################################################################
 101 use strict;
 102 use warnings;
 103 use DBI;
 104
 105 my $DB;
 106
 107 # Called when a database error has occurred
 108 sub DBError {
 109   my $msg       = shift;
 110   my $statement = shift;
 111
 112   print $msg . "\nError #" . $DB->err . " " . $DB->errstr . "\n";
 113
 114   if (defined $statement) {
 115     print "SQL Statement: $statement\n";
 116   } # if
 117
 118   exit $DB->err;
 119 } # DBError
 120
 121 # Connect to database. Note this is using anonymous access (read only)
 122 $DB = DBI->connect("DBI:Informix:lynxmigr1")
 123   or DBError "Unable to open database";
 124
 125 # Loop through ECR #s from the command line
 126 foreach my $ecr (@ARGV) {
 127   print "ECR #: $ecr\n";
 128
 129   my $statement    = "select description from defect where pkey=\"$ecr\"";
 130   my $sth    = $DB->prepare ($statement)
 131     or DBError "Unable to prepare statement", $statement;
 132
 133   $sth->execute ()
 134     or DBError "Unable to execute statement", $statement;
 135
 136   # Defect records are unique per pkey (AKA ECR) there for there will
 137   # only be one entry in @row. Also the description is returned as one
 138   # large string.
 139   my @row = $sth->fetchrow_array;
 140
 141   if (!@row) {
 142     # @row is empty if there was no ECR by that number
 143     print "Nothing found!\n";
 144   } else {
 145     my $desc = pop @row;
 146     print "Description:\n" . "-" x 80 . "\n" . $desc . "\n" . "-" x 80 . "\n";
 147   } # if
 148 } # foreach
 149
 150 $DB->disconnect;
 151
 152 exit;
 153 </pre></div>
 154                 </div>
 155                 <nav class="page-navigation entry-navigation pagination content-nav">
 156                   <ul class="page-navigation-list">
 157
 158                     <li class="page-navigation-list-item page-navigation-prev"><a rel="prev" href="http://defaria.com/blogs/Status/2005/01/files4ecr.html" title="Files4ecr">Previous entry</a></li>
 159
 160
 161                     <li class="page-navigation-list-item page-navigation-next"><a rel="next" href="http://defaria.com/blogs/Status/2005/01/tot-build-succe.html" title="TOT Build succeeds">Next entry</a></li>
 162
 163                   </ul>
 164                 </nav>
 165                 <!--
 166 <aside id="zenback" class="zenback feedback">
 167   Please paste Zenback script code here.
 168 </aside>
 169 -->
 170
 171
 172               </article>
 173             </div>
 174             <aside class="widgets related" role="complementary">
 175               <nav class="widget-search widget">
 176   <div class="widget-content">
 177     <form method="get" id="search" action="http://defaria.com/mt/mt-search.cgi">
 178       <div>
 179         <input type="text" name="search" value="" placeholder="Search...">
 180
 181         <input type="hidden" name="IncludeBlogs" value="8">
 182
 183         <input type="hidden" name="limit" value="20">
 184         <button type="submit" name="button">
 185           <img alt="Search" src="/mt/mt-static/support/theme_static/rainier/img/search-icon.png">
 186         </button>
 187       </div>
 188     </form>
 189   </div>
 190 </nav>
 191 <nav class="widget-archive-category widget">
 192   <h3 class="widget-header">Categories</h3>
 193   <div class="widget-content">
 194
 195
 196     <ul class="widget-list">
 197
 198
 199       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/ameriquest/">Ameriquest (99)</a>
 200
 201
 202       </li>
 203
 204
 205
 206
 207       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/audience/">Audience (3)</a>
 208
 209
 210       </li>
 211
 212
 213
 214
 215       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/broadcom/">Broadcom (76)</a>
 216
 217
 218       </li>
 219
 220
 221
 222
 223       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/gpdb/">GPDB (35)</a>
 224
 225
 226       </li>
 227
 228
 229
 230
 231       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-dynamics/">General Dynamics (61)</a>
 232
 233
 234       </li>
 235
 236
 237
 238
 239       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-electric/">General Electric (13)</a>
 240
 241
 242       </li>
 243
 244
 245
 246
 247       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/hewlett-packard/">Hewlett Packard (13)</a>
 248
 249
 250       </li>
 251
 252
 253
 254
 255       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/lynuxworks/">LynuxWorks (162)</a>
 256
 257
 258       </li>
 259
 260
 261
 262
 263       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/pqa/">PQA (35)</a>
 264
 265
 266       </li>
 267
 268
 269
 270
 271       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/salira/">Salira (79)</a>
 272
 273
 274       </li>
 275
 276
 277
 278
 279       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/tellabs/">Tellabs (2)</a>
 280
 281
 282       </li>
 283
 284
 285
 286
 287       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/texas-instruments/">Texas Instruments (31)</a>
 288
 289
 290       </li>
 291
 292     </ul>
 293
 294
 295   </div>
 296 </nav>
 297
 298
 299 <nav class="widget-archive-dropdown widget">
 300   <h3 class="widget-header">Archives</h3>
 301   <div class="widget-content">
 302     <select>
 303       <option>Select a Month...</option>
 304
 305       <option value="http://defaria.com/blogs/Status/2016/02/">February 2016</option>
 306
 307
 308
 309       <option value="http://defaria.com/blogs/Status/2014/09/">September 2014</option>
 310
 311
 312
 313       <option value="http://defaria.com/blogs/Status/2014/04/">April 2014</option>
 314
 315
 316
 317       <option value="http://defaria.com/blogs/Status/2014/03/">March 2014</option>
 318
 319
 320
 321       <option value="http://defaria.com/blogs/Status/2013/02/">February 2013</option>
 322
 323
 324
 325       <option value="http://defaria.com/blogs/Status/2012/09/">September 2012</option>
 326
 327
 328
 329       <option value="http://defaria.com/blogs/Status/2012/08/">August 2012</option>
 330
 331
 332
 333       <option value="http://defaria.com/blogs/Status/2012/05/">May 2012</option>
 334
 335
 336
 337       <option value="http://defaria.com/blogs/Status/2012/04/">April 2012</option>
 338
 339
 340
 341       <option value="http://defaria.com/blogs/Status/2012/02/">February 2012</option>
 342
 343
 344
 345       <option value="http://defaria.com/blogs/Status/2012/01/">January 2012</option>
 346
 347
 348
 349       <option value="http://defaria.com/blogs/Status/2011/10/">October 2011</option>
 350
 351
 352
 353       <option value="http://defaria.com/blogs/Status/2011/07/">July 2011</option>
 354
 355
 356
 357       <option value="http://defaria.com/blogs/Status/2010/09/">September 2010</option>
 358
 359
 360
 361       <option value="http://defaria.com/blogs/Status/2010/08/">August 2010</option>
 362
 363
 364
 365       <option value="http://defaria.com/blogs/Status/2010/04/">April 2010</option>
 366
 367
 368
 369       <option value="http://defaria.com/blogs/Status/2010/03/">March 2010</option>
 370
 371
 372
 373       <option value="http://defaria.com/blogs/Status/2010/02/">February 2010</option>
 374
 375
 376
 377       <option value="http://defaria.com/blogs/Status/2009/05/">May 2009</option>
 378
 379
 380
 381       <option value="http://defaria.com/blogs/Status/2009/04/">April 2009</option>
 382
 383
 384
 385       <option value="http://defaria.com/blogs/Status/2008/07/">July 2008</option>
 386
 387
 388
 389       <option value="http://defaria.com/blogs/Status/2008/05/">May 2008</option>
 390
 391
 392
 393       <option value="http://defaria.com/blogs/Status/2008/04/">April 2008</option>
 394
 395
 396
 397       <option value="http://defaria.com/blogs/Status/2008/03/">March 2008</option>
 398
 399
 400
 401       <option value="http://defaria.com/blogs/Status/2008/02/">February 2008</option>
 402
 403
 404
 405       <option value="http://defaria.com/blogs/Status/2008/01/">January 2008</option>
 406
 407
 408
 409       <option value="http://defaria.com/blogs/Status/2007/12/">December 2007</option>
 410
 411
 412
 413       <option value="http://defaria.com/blogs/Status/2007/11/">November 2007</option>
 414
 415
 416
 417       <option value="http://defaria.com/blogs/Status/2007/10/">October 2007</option>
 418
 419
 420
 421       <option value="http://defaria.com/blogs/Status/2007/09/">September 2007</option>
 422
 423
 424
 425       <option value="http://defaria.com/blogs/Status/2007/08/">August 2007</option>
 426
 427
 428
 429       <option value="http://defaria.com/blogs/Status/2007/07/">July 2007</option>
 430
 431
 432
 433       <option value="http://defaria.com/blogs/Status/2007/06/">June 2007</option>
 434
 435
 436
 437       <option value="http://defaria.com/blogs/Status/2007/05/">May 2007</option>
 438
 439
 440
 441       <option value="http://defaria.com/blogs/Status/2007/04/">April 2007</option>
 442
 443
 444
 445       <option value="http://defaria.com/blogs/Status/2007/03/">March 2007</option>
 446
 447
 448
 449       <option value="http://defaria.com/blogs/Status/2007/01/">January 2007</option>
 450
 451
 452
 453       <option value="http://defaria.com/blogs/Status/2006/12/">December 2006</option>
 454
 455
 456
 457       <option value="http://defaria.com/blogs/Status/2006/11/">November 2006</option>
 458
 459
 460
 461       <option value="http://defaria.com/blogs/Status/2006/10/">October 2006</option>
 462
 463
 464
 465       <option value="http://defaria.com/blogs/Status/2006/09/">September 2006</option>
 466
 467
 468
 469       <option value="http://defaria.com/blogs/Status/2006/07/">July 2006</option>
 470
 471
 472
 473       <option value="http://defaria.com/blogs/Status/2006/06/">June 2006</option>
 474
 475
 476
 477       <option value="http://defaria.com/blogs/Status/2006/05/">May 2006</option>
 478
 479
 480
 481       <option value="http://defaria.com/blogs/Status/2006/04/">April 2006</option>
 482
 483
 484
 485       <option value="http://defaria.com/blogs/Status/2006/03/">March 2006</option>
 486
 487
 488
 489       <option value="http://defaria.com/blogs/Status/2006/02/">February 2006</option>
 490
 491
 492
 493       <option value="http://defaria.com/blogs/Status/2006/01/">January 2006</option>
 494
 495
 496
 497       <option value="http://defaria.com/blogs/Status/2005/12/">December 2005</option>
 498
 499
 500
 501       <option value="http://defaria.com/blogs/Status/2005/11/">November 2005</option>
 502
 503
 504
 505       <option value="http://defaria.com/blogs/Status/2005/10/">October 2005</option>
 506
 507
 508
 509       <option value="http://defaria.com/blogs/Status/2005/09/">September 2005</option>
 510
 511
 512
 513       <option value="http://defaria.com/blogs/Status/2005/08/">August 2005</option>
 514
 515
 516
 517       <option value="http://defaria.com/blogs/Status/2005/07/">July 2005</option>
 518
 519
 520
 521       <option value="http://defaria.com/blogs/Status/2005/06/">June 2005</option>
 522
 523
 524
 525       <option value="http://defaria.com/blogs/Status/2005/05/">May 2005</option>
 526
 527
 528
 529       <option value="http://defaria.com/blogs/Status/2005/04/">April 2005</option>
 530
 531
 532
 533       <option value="http://defaria.com/blogs/Status/2005/03/">March 2005</option>
 534
 535
 536
 537       <option value="http://defaria.com/blogs/Status/2005/02/">February 2005</option>
 538
 539
 540
 541       <option value="http://defaria.com/blogs/Status/2005/01/">January 2005</option>
 542
 543
 544
 545       <option value="http://defaria.com/blogs/Status/2004/12/">December 2004</option>
 546
 547
 548
 549       <option value="http://defaria.com/blogs/Status/2004/09/">September 2004</option>
 550
 551
 552
 553       <option value="http://defaria.com/blogs/Status/2004/08/">August 2004</option>
 554
 555
 556
 557       <option value="http://defaria.com/blogs/Status/2004/07/">July 2004</option>
 558
 559
 560
 561       <option value="http://defaria.com/blogs/Status/2004/06/">June 2004</option>
 562
 563
 564
 565       <option value="http://defaria.com/blogs/Status/2004/05/">May 2004</option>
 566
 567
 568
 569       <option value="http://defaria.com/blogs/Status/2004/04/">April 2004</option>
 570
 571
 572
 573       <option value="http://defaria.com/blogs/Status/2004/03/">March 2004</option>
 574
 575
 576
 577       <option value="http://defaria.com/blogs/Status/2004/02/">February 2004</option>
 578
 579
 580
 581       <option value="http://defaria.com/blogs/Status/2004/01/">January 2004</option>
 582
 583
 584
 585       <option value="http://defaria.com/blogs/Status/2003/12/">December 2003</option>
 586
 587
 588
 589       <option value="http://defaria.com/blogs/Status/2003/11/">November 2003</option>
 590
 591     </select>
 592   </div>
 593 </nav>
 594
 595
 596
 597 <div class="widget-syndication widget section">
 598   <div class="widget-content">
 599     <p><img src="http://defaria.com/mt/mt-static/images/status_icons/feed.gif" alt="Subscribe to feed" width="9" height="9" /> <a href="http://defaria.com/blogs/Status/atom.xml">Subscribe to this blog's feed</a></p>
 600
 601   </div>
 602 </div>
 603
 604             </aside>
 605           </div>
 606         </div>
 607         <footer id="footer" role="contentinfo">
 608           <div id="footer-inner">
 609             <div id="footer-content">
 610   <nav role="navigation">
 611           <ul>
 612             <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
 613
 614
 615           </ul>
 616         </nav>
 617
 618   <p class="license">&copy; Copyright 2016.</p>
 619   <p class="poweredby">Powered by <a href="http://www.movabletype.org/">Movable Type</a></p>
 620 </div>
 621           </div>
 622         </footer>
 623       </div>
 624     </div>
 625     <script src="http://defaria.com/mt/mt-static/jquery/jquery.min.js"></script>
 626     <script src="http://defaria.com/blogs/Status/mt-theme-scale2.js"></script>
 627   </body>
 628 </html>