DSXchange

This is a message that the osh is wrong in some way. Why are you trying to write in Osh? Why don't you create your job using the Designer? Hi Eric, The requirement is such that my output schema is fixed, but the input schema may vary for each file. Also I am having one file that will give which out...

Find where gdb is and make sure that its parent directory is in the PATH. Hi Ray, I have searched on my Unix machine and there is no executable with the name gdb. I dont know if this problem is exactly related to gdb only or some other thing since if it is a gdb problem then I would not have been a...

Hi All, I am trying to create the osh script for some small logic. Following is the code that I have written in the osh script:- transform -outputschemafile 'out_schema' -inputschemafile 'schemaforos' -expressionfile expfile -flag compile -dir '/home/dsadm/testDS/OshTestSal' -name transferfile; impo...

Hi, Thanks Brad and Thomsonp for ur suggestions. I was able to partially solve the problem. The problem why I was not using the APT_String was that it consists of const char* type record. But we were applying the complete logic in C++ by passing the character string to a function. So if I change thi...

[quote="richdhan"]Hi Nripendra Chand, Use the following conversion. You should be through. Trim(Field(DecimalToString(INPUT_COLUMN),".",1)) HTH --Rich[/quote] Hi Nripendra, Also after doing the above conversion don't use any derivation in your StringtoDate function, just use it S...

Hi, I am trying to create a build-op stage that takes the input column and do all the processing on that field and pass it to output. Input column is coming as Varchar field. Can anyone please tell me how to copy this VarChar column to a string and also how to find the total length of this varchar f...

Hi,

You can find the utilities for command line export and import from DataStage Manager guide.

There are two utilities called dsimport.exe and dsexport.exe by which you can take the import and export from command line.

Regards
dsusr

Hi Craig,

I have tried doing the server installation again and the problem get solved but is there any specific reason why this plug-in dont get installed using command "dspackinst".

Thanks for your suggestions.
Salman

Hi Kumar,

You can use the same utility by using the Basic Transformer in your parallel canvas but you need to pass the number of records in source as a parameter to the job.

Then you can implement the logic by using stage variables in the transformer.

Regards
dsusr

Hi Rick,

You can get the job logs using "dsjob" command from $DSHOME/bin and after every job run you can retrieve the log using dsjob and can store in some file.

Regards
dsusr

[quote="chulett"]How did you install it?[/quote]

Hi,

I have installed it using the "dspackinst" utility in $DSHOME/bin directory. After installing, I have restarted the server also.

Please let me know if some other thing needs to be done.

Thanks
dsusr

Hi All, I have installed the pivot plug-in stage at the server but when I am trying to use the pivot stage it is giving the following error:- [u]main_program: PATH search failure: main_program: Could not locate operator definition, wrapper, or Unix command for "dscapiop"; please check that...

Hi All, We are trying to use Combine Records stage. Input file contains just 3 columns i.e. key_col(Char(1) ), col1 ( TinyInt), col2(Time) and data that is present is A,1,00:10:00 A,3:00:03:00 Now while trying to run the job by combining the records with "key_col" as combine key we are get...