Hi ShaneMuir ,
Could you tell me in more detail or If possible can you provide me the unix commands pls.
Search found 263 matches
- Wed May 06, 2009 8:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: extract header and footer info from fixed width file
- Replies: 10
- Views: 5208
- Tue May 05, 2009 8:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: extract header and footer info from fixed width file
- Replies: 10
- Views: 5208
- Tue May 05, 2009 7:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: extract header and footer info from fixed width file
- Replies: 10
- Views: 5208
- Tue May 05, 2009 6:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: extract header and footer info from fixed width file
- Replies: 10
- Views: 5208
extract header and footer info from fixed width file
Hi, My requirement is: Source: Fixed width file Target:Fixed width file Source file contains header and footer, i need to store that info into a table(staging), and include them while loading into target fixed width file. Could anybody give me an idea how to proceed with this requirement? Thanks in ...
- Thu Apr 30, 2009 4:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lower case verification in string
- Replies: 2
- Views: 1825
- Thu Apr 30, 2009 3:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lower case verification in string
- Replies: 2
- Views: 1825
Lower case verification in string
Hello All, My input data coming like: AA BB USD 100 USd 101.23 GBP 200 GBp 203.45 Target column is: CC The requirement is, If the last charecter in AA column is lower case(EX: 'd' or 'p') then I need to divide the column(BB) with 100 and load into target column i.e. CC Could you please let me know h...
- Mon Apr 20, 2009 3:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Clearing job logs in director for multiple instance of a job
- Replies: 4
- Views: 2547
Clearing job logs in director for multiple instance of a job
All, I am using a unique id(for ex: batch_id)as a invocation id for my master sequence. Every time I run the job sequence for multiple times in a day, it is creating the multiple job logs(in status view-DS DIrector) with batch id as invocation id. For ex: My sequence name is 'ABC' and it is checked ...
- Mon Apr 06, 2009 11:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequential File
- Replies: 1
- Views: 1488
- Mon Apr 06, 2009 10:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequential File
- Replies: 1
- Views: 1488
Sequential File
Hi, We have a simple job which reads from a TAB delimited Seq file and applies a couple of simple transformation rules and then writes to an Oracle Table. Strangely when I run this job, it imports 50% of the data from the file and hangs..does nothing..I have to eventually stop the job. The DEV env h...
- Thu Mar 26, 2009 5:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dataset Deletion Error
- Replies: 4
- Views: 5975
previous delete attempt not complete
See we are focussing on the solution, can any one tell us what is the cause of this warning message, see we can't delete the datasets each time while running our job in all scenerios, atleast not possible in our case. Please help me to know the cause fo this warning.
- Thu Mar 12, 2009 1:17 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: UTF-8
- Replies: 0
- Views: 1160
UTF-8
Hi
We are using DS 7.x
Source/ Target is Oracle
Oracle :- NLS_NCHAR_CHARACTERSET = AL16UTF16
DS:- NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1
If the NLS_NCHAR_CHARACTERSET on oracle is changed to UTF8, what will be the effect on the existing jobs
Appreciate your response
Thanks
We are using DS 7.x
Source/ Target is Oracle
Oracle :- NLS_NCHAR_CHARACTERSET = AL16UTF16
DS:- NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1
If the NLS_NCHAR_CHARACTERSET on oracle is changed to UTF8, what will be the effect on the existing jobs
Appreciate your response
Thanks
- Thu Feb 26, 2009 1:57 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Server lookup returns only the first value
- Replies: 2
- Views: 2002
Server lookup returns only the first value
Hi,
Source is Oracle and reference stage is oracle, when we perform lookup using transformer, it returns me only the fisrt value(duplicate values) to the output from the reference stage but if we view the data from reference stage , i can see multiple distinct records.
Please adivce.
Source is Oracle and reference stage is oracle, when we perform lookup using transformer, it returns me only the fisrt value(duplicate values) to the output from the reference stage but if we view the data from reference stage , i can see multiple distinct records.
Please adivce.
- Sun Feb 15, 2009 2:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: FTP Stage issue
- Replies: 3
- Views: 2912
FTP Stage issue
Hi All, I am getting the issue with FTP stage. My job design is like specified below. Approach 1: FTP Stage------>Sequential File FTP_Enterprise_0: uri : ftp://HOST/PATH/filename.txt is not valid remote file. But i have a file in the above specified remote path. Approach 2: Sequential File------> FT...
- Sun Feb 15, 2009 1:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Complex Flat File Issue
- Replies: 10
- Views: 3858
Complex Flat File Issue
Hi,
Iam Getting an issue with complex flat file,
Job is Aborting,because of SIGBUS Error.How to resolve it.
Error:Operator Terminated Abnormally:received signal SIGBUS.
Thanks,
sirisha.
Iam Getting an issue with complex flat file,
Job is Aborting,because of SIGBUS Error.How to resolve it.
Error:Operator Terminated Abnormally:received signal SIGBUS.
Thanks,
sirisha.
- Fri Feb 13, 2009 7:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: issue with surrogate key stage
- Replies: 1
- Views: 1575
issue with surrogate key stage
Hi All, I have a scenario to generate the sequence numbers with surrogate key stage for a sequential file. In version 7.5 i am able to generate the incremental sequence numbers. But in 8.0.1 it is not generating the incremental order. My job design is File------>Surrogate Key Stage------>File I have...