DSXchange

Hi- We are using rsync command to transfer files to remote server using Command stage in a sequencer and writing the command logs to a file. I would like to capture command log to director so that our log retention script can capture log from director and put it in database. Is there any way to writ...

No. DataStage generates decimal numbers with leading and trailing zeroes as specified by the precision and scale. Remember, too, that text files do not really have data types - everything in them is "string" or "text". So changing your metadata is, in this case, slightly more co...

ArndW wrote:Use DecimalToString(In.ColumnName,"suppress_zero") and I'm fairly certain it will work.

It is working. Thank you very muck Arnd.
Is there any other way can I achieve this without changing metadata?

Thanks,
Chandra

I'm not at a DS window to test but would think that if you declare the output sequential file as varchar and do a DecimalToString conversion that these leading and trailing zeroes would disappear. Have you tried this? Thanks for the reply. I have this issue for both Varchar and decimal fields. I tr...

I don't think it's possible to use DS functions in before-SQL. A reference to a DS macro (surrounded by "#" characters) may be possible, but I'd be dubious about that too.

This works
call dbms_application_info.set_module('DS', '#DSJobName#');

Thanks for you support Ray

hi guys- i have to pass a job name to a oracle proceure in before sql (call dbms_application_info.set_module('Parameter1', 'parameter2'); parameter1: i will pass some hard coaded value parameter2: i have to pass job name my least option parameter2 is hard coading job name. i have to call this proced...

Hi All we are migrating DS Server from windows to Unix. surrogate keys are generating in current system using KeyMgtGetNextValueConcurrent routine. i think these keys will be stored in a file called SDKSequences . correct me if i am wrong. how to migrate the values stored in SDKSequences . if you ha...

kris007 wrote:Did you try what I have suggested? It might solve your problem. Why don't you give that a shot

Kris-

it did not worked out. i found there is a new line characters in the data
i fixed it using Ereplace(arg1, char(010),'').


Thank You
Chandra

So what you are trying to say is that First record has 4 columns Second column has null values (how many columns?) Third record has only one column? Is this your target file. How did you populate this file. Or this file is your source file? But i thought your source is SQL Server. If there is metad...

Ok help me understand The first record is Column1: 123 Column2: 126 Column3: 789 Column4: Dear Sir/Madam, What is record 2? Does record 3 only have "Kindly help me to change the store number from S63 to S063.. Thanks Azila" as a value? What column does this value belong too. What values d...

Hi Guys i have a situatio where i am populating 4 columns from sql server to a flat file. one column is a varchar of length 2000. The date in the column like "Dear Sir/Madam, Kindly help me to change the store number from S63 to S063.. Thanks Azila". This column is dividing into 3 records ...

DSguru2B wrote:Yes. I totally forgot about that. My solution will work for files that are created in an account. For pathed a different approach is required.

Jules Renard-

we are using account for hash file creation. your solution is working.
thank you for helping me.

Best regards
Chandra

Hi Guys

i have a situation where i am creating hash files like FileName_Date
i need to delete these hash files once entire batch has run.
we are using DataStage Server Edition 7.5.1 in windows environment.

anysuggetion to sort this issue?

thank you
chandra

Ok... a new hunch... - Analytic functions are not supported in Oracle8i (actually from 8.1.6 onwards). They are supported from Oracle9i. - So could it be you're using the OCI8 stage instead of the 9 version? It works for your SQL Editor as you have the same version of client and server, while it do...

thank you, but it is not the problem. i tried quey by removing "--" also but it gave me same error message Can you post your new query? Ogmios here is my new query select s.store_num, s.rgstr_num, TO_CHAR(dc.cal_dt,'YYYY-MM-DD HH24:MI:SS'), s.rgstr_type_cd from ( select STORE_NUM, RGSTR_N...