DSXchange

I want to concatenate two files file1 and file2 and use that in sequential file stage.

cat file1 file2

Can I use cat #file1# #file2# (i.e) parametrizing them? and where can I write this cat command?

Hi,


I have got a folder stage and say i just need to read two specific files i.e. file1.txt and file2.txt out of 100 files in that folder. How can I do that?


Regards

Could you give me the link of documents if at all you have it with you. Google is leading me all places around :D

Hi,

I want to connect to Oracle, Informix and SQL server via unix (not from DS).

What all will i require and how can i connect and run SQL queries. The result of which i need to use in datastage.

Thank you

Thanks for the help

I want to connect to SQLServer, and I am using Ascential 7.5.1. I dont see any plugin of SQLServer. Is it abnormal, not to have plugin for SQLServer??? Will DRS (Dynamic RDBMS stage), work to extract data from SQLServer??? (I heard this from someone,but not for sure). or do i need to go for ODBC onl...

Can a view have more than one table in it. If at all yes. then how do i read from different tables. Like say I have VIEW - Table1 - ID1 - ID2 - Value1 - Table2 - ID2 - Value2 Extract Requirement ID1 ID2 Value1 Value2 do i need to say select ID1, ID2, Value1, Value2 from VIEW where Table1.ID2=Table2....

I need to check duplicates based on Field1 and Field2

Hi, A small question. If I have got two fields, Field1 takes upto 10000 values and Field2 takes upto 4 values. which would be the better way (performance) to specify the properties in the sort stage. a) Field1 ASC, Field2 ASC b) Field2 ASC, Field1 ASC c) Doesnt matter My Hinch is (a) Thank You

Hi shawn_ramsey, We are running Netezza with DataStage and want to get a better feel for how many other folks are in the same boat. Considering the number of issues we are seeing with the Netezza plug-in I feel like we are the only ones running the plug-in. Hi we as well are using Netezza with DataS...

Sorry, by intact, i meant, can I use the same sequences, except that in job activities this time i will be calling parallel jobs (we didnt get the parallel extender yet, so no chance to try them yet).

presumably yes, but just wanna double confirm.

Hi, We have current jobs/sequences done in server 7.5.1. Planning to have 7.5.2 where we want to do the jobs in Parallel. Can we have the Sequences used in the server intact?? i.e. We currently have routines/jobs build up to get the data from database and load as job parameters into the job activiti...

The way you define in you job property. If you assign the PW as string, you may need to pass on the just the plain test, if you marked it as encrypted, datastage expects a string which it would try to decrypt during the run time. The reason why I am confused here is that my present design (done by ...

Hi, Thanks for the help. I am going to try it today (monday). Yesterday was sunday, wasnt able to try. I am sure it will work when you have said it :D . But I dont seem to get the concept. I wanted to know how the work goes on by the datastage for this encryption stuff (like pw, pw_encrypt1, pw_encr...

But If i copy and paste the encrypted password in the flat file, then will the datastage not encrypt the already encrypted password again causing some new password which will not be able to access the database. How come it works if we do it this way? I mean lets say we have pw pw_encrypt1 pw_encryp...