Search found 166 matches
- Wed Jun 17, 2009 4:37 am
- Forum: General
- Topic: Reading XML files - Repetition elements
- Replies: 10
- Views: 16760
If i remember correctly, You could cascade Multiple XML stages also Something like this: <Cust> <Name> </Name> <AddressList> <Address> Address1 </Address> </AddressList> <PhoneList> <Phone> Phone1 </Phone> </PhoneList> </Cust> external source stage -----> xml stage1---(Get Name/AddressChunk) -----> ...
- Mon Jun 23, 2008 4:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: generating schema file
- Replies: 10
- Views: 5869
- Mon Jun 16, 2008 12:13 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: data extract and load SAP CRM
- Replies: 5
- Views: 3715
screenshots would be difficult!!!! I havent worked with BAPI's a lot though i believe a BAPI returns a status code back to the calling program. This can be written to a file using the BAPI stage. Cant help you much there. However for IDoc stages, there are 2 types of issues that may come up : :arrow...
- Fri Jun 13, 2008 4:47 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataBase Extract, Merging Rows
- Replies: 3
- Views: 2022
- Fri Jun 13, 2008 4:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job aborts - Alpha function
- Replies: 2
- Views: 1993
I think the problem is to do with:
Trim will not take kindly to a null value as input
try this:
Code: Select all
Trim(Lnk_Read_ds.NAME_LINE)=''
try this:
Code: Select all
If Trim(NullToEmpty(Lnk_Read_ds.NAME_LINE))='' Then 0 Else If Alpha(Trim(Trim(Trim(Lnk_Read_ds.NAME_LINE),'-','A'),' ','A')[2,39]) Then 1 Else 0
- Fri Jun 13, 2008 2:59 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: data extract and load SAP CRM
- Replies: 5
- Views: 3715
the SAP R/3 pack can do the following: 1. Extract/load data from/to SAP R/3 using IDOC's 2. Extract/load data from/to SAP R/3 using BAPI Calls 3. Given a Logical DB SQL Statement (Built via provided GUI in the stage), generates an ABAP program that extracts data from SAP using CPIC or Write to file....
- Fri Jun 13, 2008 2:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: JOIN STAGE
- Replies: 3
- Views: 3640
Sumit, From what i understand of your issue: You are attempting to do an inner join between 2 tables in datastage via the Join Stage. The expectation is that the join should only extract rows that qualify( i.e. where invmst.sku# = invbal .sku# and invbal .store# = 250) from the INVMST stage. However...
- Mon Jun 09, 2008 5:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading problem with Sequential file
- Replies: 3
- Views: 2576
- Thu Jun 05, 2008 3:26 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: A Registry Read Function in DataStageTX 8.0 ?
- Replies: 14
- Views: 12935
- Thu Jun 05, 2008 3:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Yet another Pivot Question (bit different though)
- Replies: 4
- Views: 2694
- Mon Jun 02, 2008 6:05 am
- Forum: General
- Topic: Best way to abort a job
- Replies: 13
- Views: 7449
- Mon Jun 02, 2008 5:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Re-partition
- Replies: 5
- Views: 3005
- Fri May 30, 2008 8:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Join Header and Tralier
- Replies: 12
- Views: 6128
- Fri May 30, 2008 2:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Join Header and Tralier
- Replies: 12
- Views: 6128
In an External Command Stage, use the following Source program:
replace <FilePath+Name> and <Delimiter> with the appropriate text.
HTH.
Code: Select all
echo "`head -1 <FilePath+Name>`<Delimiter>`tail -1 <FilePath+Name>`"
HTH.
- Thu May 22, 2008 5:24 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Using environment varaible in the job paramter
- Replies: 6
- Views: 3774
Re: Using environment varaible in the job paramter
Here is the Job Paramter #FromClause# = prdtbl where #$LoadType# =1 Here is how the SQL looks when we use SQL generated option SELECT ABC FROM #FromClause# Assuming you call the job from a sequence, add a uservariable activity before the job activity stage and create one uservariable "FromClau...