DSXchange

Hi DS gurus

I want to know if there is a way to find the list of all the underlying jobs that a sequencer is using irrespective of the way it is designed?
(For example Job properties in Batch jobs list every job taht the batch job is calling )

Is there a way to find this ?Please let me know?
Thanks

Hey everybody Have a quick question about one of the issues in parallel , can you let me know what is the best way to compare rows in parallel ? Scenario I have rows like a xyz a pqr a yrd Functionality needed Compare row 1 and row 2 if the entry in first row is same (here a ) then comcatenate colum...

Thanks Creig

Hi everybody,
Is there a way one could stop (not log) a perticular error message(say customer information etc)?

Thanks

Thanks for your inputs. But why does the documentation say that during sparse lookups you can have only one ref link . Does it mean that when you are using oracle or DB2 stages you can use one and only one refernce link (oracle or DB2 stage) ? Please correct me if I am wrong . It is really confusing .

Hi All

Can we use multiple refernce links(From different oracle Odbc stages) to single lookup stage in parallel ?


Thanks

Hi All We are currently in EE 7.5.1 and when I try to view data from an empty table it gives me an error which says floating point data mismatch error on top of saying that there is no data in the table. when i try to push in some rows and view the data the view data works fine and it shows up all t...

Hi Everybody I have a datastage job that is using EBCDIC(FMT(COLUMN_NAME)) it looks like whenever there is a null value for the column (column_name),the job aborts. This is the error that shows up DataStage Job 1307 Phantom 7596 Program "JOB.1752826515.DT.1437551087.TRANS2": Line 100, Impr...

Hi All I have the following error message when I try to insert records in D_UNIT_Measure table (SQL SERVER) , this has UOM_ID as the primary key and in indexes it shows up PK_D_UNIT_Measure(clustured) and UOM_IDX(Unique,Non Clustured) ? I have problem in understanding the error as I know for sure th...

Hi all I have a job with one odbc loading data into a seq file via a transformer . This is the part of my job which i was testing it gives me the following error main_program: Data set, file set, or file "Transformer_12:DSLink16.v": Non-pipe (or non-virtual data set) with .v in its name [s...

Hi all

Can anybody please tell me how to Convert Jullian to gregorian dates and timestamps in px ?


Thanks

Hi All I have a simple test job Seq File - Aggregator - Seqfile Currently the input seq file has three columns Name(varchar) SAL(Varchar) Number (Numeric0 When I try to view the data from the input file it shows only the first and last rows of data if I define the datatype for Number Column as Numer...

Hi All

I am new to datastage
Can you please let me know , where do I find Configuration file ?

Enabling the record delimiter property to DOS fixes the problem ,but I still don t understand the reason for this

Thanks

the sequential file you generated manually is different from using datastage when your ds server is Unix,i guess you must generate it in windows then transfer to Unix,that makes the different.if you directly generate it in unix,the file can be the same with datastage generated.you can compare the f...