DSXchange

jerome_rajan

Aaaannnnd....It's back again quickly replacing the topics of importance on the front page!

jerome_rajan

Hi, I just got this unusual requirement from our client to upload a Microsoft Word file into a DB2 Database as an object using DataStage. I'm not sure where to start. I'm not even sure if I should be accepting a requirement such as this. What should be the datatype of the DB2 column storing this obj...

jerome_rajan

Dear All, We have a file that serves as kind of a master and holds data that should go into two different target tables with completely different metadata. Our source file looks something like <Line1> a,b,c,d g,h,i,j <line2> 1,2 3,4 5,6 <line3> garbage <line1> f,g,h,k <line2> 1,2 7,9 <line3> garbage...

jerome_rajan

Use 2 stage variables.

Code: Select all

svStart = svEnd
svEnd = lnkSrc.Date (initialize to 0001-01-01)

Assuming that your output columns are as below

Code: Select all

Constraint --> svStart<>0001-01-01

StartDate --> svStart
EndDate -->DateOffsetByComponents(svEnd,0,0,-1)

Hopefully, this should work.

jerome_rajan

No. It will not affect the performance in any way. What you encountered was just a warning telling you that no matter what 'YOU' want, the stage will partition data the way 'IT' wants. Clearing the "preserve partitioning' flag will serve only as far as eliminating the warning.

jerome_rajan

Thanks Ray.

We're looking for a dynamic solution. I lost you at

...a sequence to read the table name from each file and set a job parameter containing the table name...

Can you please elaborate?
I'd be very interested to know how the XML Stage can help since that would mean a purely parallel job.

jerome_rajan

We are faced with a slightly tricky situation here. We have source data coming in a single table. This table say 'SOURCE' has a column called 'TGT_TBL_NM' that defines the name of the target table that the corresponding row is inserted into. A sample of our source looks like col1 col2 col3 TGT_TBL_N...

jerome_rajan

Great! :D Going to try it first thing when I reach office. Thanks for sharing.

jerome_rajan

1. Using vi editor
A. :s/search_string/replacement_string/g

2. Without using vi editor.
A. sed s/search_string/replacement_string/g <filename>

jerome_rajan

How do you differentiate between what forms the initials and what forms the first name? Or are the 'Initials' stored in a separate column?

jerome_rajan

Are you adding the APT_STRING_PADCHAR variable in one job (say your transform job) and loading using a different job?

jerome_rajan

Is this a bit like the 'Otherwise' functionality in the PX Transformer?

jerome_rajan

I think OCONV requires the argument in the internal format as generated by ICONV.

jerome_rajan

You can edit the .dsx file created after the export. Look for a property called "Category' and edit the path. The edit process should be evident once you see the property yourself. I haven't tried it out myself. May be you can tell me?

jerome_rajan

db2, oracle, sas, informix are some of the keywords that can be used to create pools besides "sort".

DSXchange

Search found 376 matches

Loading a Word Document

Filter ranges of records in a file based on search strings

Target Table Name in Source Column