DSXchange

Hi all!! I have a situation where i have to check the Phone Number field, whether its all Numeric. I have dealt this scenario previouly by writing a Routine. But that was a Server job. Now i need to do this in parallel job. Could anyone suggest if if there is any such function in Parallel jobs or Ho...

hi,
this is not a pure datastage question. but related to ODBC. i want to see the MAXRESPSIZE in the odbc.ini file. but not finding it in odbc.ini. where can i find it?
Thanks.

hi All, i have a master sequence which runs many jobs which grab data from different source files and finally only one M-load is done into teradata. but some times when i don't have a file for one of the sources then i just want to pass a parameter of the source name so that my job runs only that pa...

There is a file consisting of Name, Phone Number. My job is to verify if the records have duplicate phone numbers with the same name. If say a person A appears twice in the file, First time with Phone No 1 and second time with Phone No. 2 then only the record with Phone no. 1 has to survive where as...

hi All,
i got to do a look up on a file using the same file as i have to concatenate data becos it got split. so i have to reject data which has duplicate key columns data. how and what constraint should i use. kindly suggest.
thanks

i did not exactly follow the suggestion. can you explain?
Thanks

hi All, my data is so bad that the emailaddress got split into different rows with all the same other details. eg: order_nbr emailaddress seq_id 100 Y, 6 100 DSkkk@yahoo 7 100 .com 8 i have the column seq_id which has the consequent nos for the continuation. now i have to concatenate the whole email...

hi all,
i have a question about grabing data from two different tables with a single ODBC .
can we just grab the data from 2 tables loading the defnitions one after the other in one ODBC.

due to selections from the table to which you are loading there can be a lock.
use clean up resources in the director to release all the locks and then try running your job again.
if that doesn't work then ask your datastage administrator to bounce the server.

hi All, i am concatenating three columns and doing a look up on the concatenated column as a key on a an other concatenated column of a different table. i used the constraint If IsNull(concatenated) then Not(rejected) Else rejected. the look up is not done and there are '0' rows from the second tabl...

Hi Vmcburney, you siad that i can feed in just the primary data and let QualityStage open the match data file directly from a flat file and not from a DataStage link. i see in the documentation for the plug-in that When you run a match, the data file should be bound to a QualityStage stage link, whe...

Hi all, i am able to run my standardization jobs using QS plug in for DS. now i have to run my Match job using the plug-in. the problem is i canoot use both the files as input to the QS plug in as it does not support reference links. and the report and extract files do not contain any metadata defin...

hi All i need to automate the process of FTPing the source file from remote host to the local directory. i am writing the shell script to FTP the latest file from the remote directory. but the general ls -1t |tail -1command does not work in the ftp part. what is the command to pick the latest or las...

hi All, i am extracting data from one table of teradata and putting it to another making some necessary transformations. if i run this job today then i am supposed to get the new records in the input table since last run date. but my input table doesn't have any column as timestamps to compare. if i...

hi all, i want to append a new column from a file which has only 1 row to another file which has three other columns. i do not have any common columns. but the output file should have all the rows of the second file populated with the same data of the only row in the first file. for example: **first...