DSXchange

Hi,
We need to pass 2 column values from a Seq Stage to a User defined Query in ODBC lookup Stage ( the Number of rows concerned is less ). We are doing a MAX on a column's value in the query.
How can we do it ?

Thanks

dsrules

Thanks Kim. We are using Stage Variables for it !

Hi, We are trying to fill in missing rows among three tables. For Ex: The present scenario TABLE A TABLE B TABLE C ID,Date,Amt ID,Date,Amt ID,Date,Amt 10000003,1/31/2004,100.00 10000003 1/31/2004,120.00 10000003,1/31/2004,90.00 10000003,2/28/2004,200.00 10000003,2/28/2004,145.00 10000003,3/31/2004,1...

Ketfos,
Execute on the Admin client window, if you have the Admin rights. Else ask your Admin to do it. Alternatively you can unlock it by Inode number after getting the Inode numbers for the jobs locked.

dsrules

Looks like the person asking these questions is not sure of the exact answers :D ,
You can have a field day with such guys
Cant see many real time scenario question's. What say?

dsrules

The path variable should include this path dsrules

p1tom,
You need the the TeraData client utilities installed. Check for FastLoad.exe if it exits in the installation folder. The Path variable should have the path to the folder where these utilities reside. Also re-boot your Server for the change of path to be reflected.

dsrules.

Kim, dont you think those questions were in bad taste?. I hate to see people utilizing this forum for "Interview" kind of questions rather than have a real time problem. We are lucky to have the best experts and guru's in this forum. Thanks for all the support. What does Ray, Ken, Chulett ...

ArndW,
I fixed it :D . The error was the Meta data was s9(10)v99 but in the mainframe they were explicitly signed. I got them onto DataStage using pic x(12) then loaded them into sequential file as decimal. This works fine. Please let me know if I am doing a right thing.
Thanks
dsrules

Hi,
I am using CFF stage to view data downloaded from mainframe. Everything looks right except the decimal columns have .. rather than a single . separating the scale and number.
Any help is appreciated.
Thanks
dsrules

Include TeraData in it.

dsrules.

Hi Ray,
I wanted to know how do we specify the path name for the batch file , I know the shell value would be 'NT', what would be the command value if I have a XXX.bat file to run. Can you please elaborate.
Thanks
Mack

Hi, I need to invoke a batch file and read the status code. I read the manual , it says about DSExecute(ShellType, Command, Output, SystemReturnCode) Also there is an option for creating a Batch Job in Director or in Sequencer. I want to know how do we specify the file name and path of the batch fil...

Hi, I am trying to load a table in TeraData using the Fast Load plug-in. the error is Unable to start FastLoad process fastload: system returns 2: The system cannot find the file specified I could see the control file and data file being created in the specified directory. I could also load the Tera...

Arnd, I also need row count. I found a post in which Ray walks through parsing the GetJobReport file . The post is http://www.dsxchange.com/viewtopic.php?t=90193. But in this way how can I automate the process of knowing the file name. The file name is JobName_YYYYMMDD_HHMMSS.txt I want the file nam...