Search found 147 matches
- Mon Nov 19, 2007 1:35 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Invalid character value for cast specification
- Replies: 7
- Views: 4804
- Wed Nov 14, 2007 9:31 am
- Forum: General
- Topic: Error Executing a Shell Script via Sequencer
- Replies: 2
- Views: 2749
Repeating on the above reply, just pass the path of where your .TXT file resides and use it like below in your shell script. SERV=$1 USER=$2 PASS=$3 DBN=$4 BTEQ_DIR=$5 BTEQ_FILE=$6 bteq << EOF .logon $SERV/$USER,$PASS database $DBN; .SET ERRORLEVEL 3807 SEVERITY 0; . run file = $5/$6 .LOGOFF; .QUIT;
- Thu Nov 08, 2007 1:42 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Finding a particulor column in all the Teradata tables
- Replies: 4
- Views: 4301
Select DatabaseName, TableName, ColumnName, ColumnFormat, ColumnTitle, SPParameterType, ColumnType, ColumnUDTName, ColumnLength, DefaultValue, Nullable, CommentString, DecimalTotalDigits, DecimalFractionalDigits, ColumnId, UpperCaseFlag, Compressible, CompressValue, ColumnConstraint, ConstraintCount...
- Thu Nov 01, 2007 1:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Passing parameters to a sequence via text file
- Replies: 5
- Views: 1919
Create two files (1) 1 shell script (example- loadcountry.sh) that will execute your job can be like one below START SHELL SCRIPT . /companydir/paramfiles/paramvalues.txt ###################################################################### # DataStage Parameter Processing: ########################...
- Thu Nov 01, 2007 1:35 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: File from FTP
- Replies: 9
- Views: 3679
- Thu Nov 01, 2007 1:06 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: File from FTP
- Replies: 9
- Views: 3679
Basically just extending the reply by Chulet. (1) Design a job that gets file from using FTP Stage OR (1) Write a shell script that get's the file using FTP to ETL Server.(abc.txt) Once the file is downloaded, just rename it (def.txt) (2) Design a master sequencer that calls above job. In a routine ...
- Thu Oct 11, 2007 1:28 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: FTP issue from ETL Server to Mainframe
- Replies: 2
- Views: 1312
There are some parameters that are used when uploading files on Mainframe, You might want to use something like below FTP www.hostname.com user myuser mypasswd ascii (or binary whatever the case may be) Quote Site Tracks Primary=NN Secondary=NN Quote Site LRECL=NN PUT abc.txt 'fprod.test.abc.txt' By...
- Thu Oct 11, 2007 1:17 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem with DB2/UDB Load Stage
- Replies: 5
- Views: 2407
Directory for Data and Command Files This folder on your ETL server will hold the .CTL and .DAT file. Make sure datastage user has write permission to this fodler. When you use bulk load, ETL creates the .DAT file that contains data and a .CTL file that is nothind but command file to load the .dat ...
- Tue Sep 25, 2007 11:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Modify Stage Question - Multiple conversions
- Replies: 7
- Views: 3579
- Tue Sep 25, 2007 11:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Decimal Rounding Issue
- Replies: 3
- Views: 1350
- Thu Sep 20, 2007 7:51 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: surrogate key generation in server jobs
- Replies: 13
- Views: 6475
In order to be sure that nextkeyvalue is not messed up, I always use this option: (1) Once I am at the transformer where all database column is ready, I drag a query and do a select MAX(KeyCol) from Table and then get that value through a lookup. Once you get the MAX value from target table, you can...
- Mon Sep 10, 2007 7:37 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: how to design with optimal performance...........
- Replies: 6
- Views: 1454
(1) Please post all your 5 statements clearly, so that we can what exactly is being done. (2) How much data is being processed .i.el loaded to DB2 table? (3) Any other transformation happening in the ETL flow, or just select and dump data in DB2? Replies to above will help to answer how to performan...
- Mon Sep 10, 2007 7:28 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Creating Table DDL Dynamically from DataStage
- Replies: 5
- Views: 6306
The way I do is, First dump all the Columns I need in a text file. So, now I have all the metadata I need for the table. Then, from the same transformer that feeds the text file, I take 1 more link and connect to a teradata Table Stage (Enterprise, API) [if one is using teradata] On the Table proper...
- Wed Sep 05, 2007 8:33 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: reject handling
- Replies: 8
- Views: 2522
Few years back, I had a long discussion with some Datastage people regarding this same issue while working on performance tuning project on Datstage and UDB DB2. Basically, they were setting the ArraySize=1, in almost all the jobs they had because they wanted to capture any rejects from the database...
- Wed Sep 05, 2007 8:15 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Join 2 tables in DB2
- Replies: 8
- Views: 2269
If I understood your question correctly, why not to run a simple SQL statement? Bascially, you want to get all values on COLA from Table DEF that doesn't exist in Table ABC and then write those values to ABC table. How is this SQL? Use UserDefined SQL at the DB2 source, get the rows in transformer a...