DSXchange

Clear the preserve partitioning flag in the stage before sequential file stage

Thanks

I am using Date() function to get the current run date.After getting the date I am using DateGenericGetYear(Date()) to get year from the date. The same logic worked before and now after so many months in the production the date function is giving internal date value,because of that i am getting the ...

If i use load method in oracle enterprise stage it uses oracle SQL loader.My question is where it will store the control file bad file ,data file.I saw one file in the scratch.what about the remaining Datafile,ControlFile and badfile. what is the meaning of this \\.\pipe\ora.4268.343000.fifo.0 where...

I am also having problem with the open command.when i try to update some thing in the table it is not updating but when i write that record to the file it is writing the record with new updated value.But when i go check in the data base that is value is not updated.Even after changing oracle commit ...

I am using DB2 Enterprise stage to reda data from db2 UDB which is on AIX system.I am getting the following error.Can any one please tell me what is the problem. ##I TFCN 000001 11:42:17(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5.2 Copyright (c) 2004, 1997-2004 Ascential Soft...

Hi, we are using shell scripts to call our datastage jobs.All the parameters are coming from the shell sccript.But for old sequencers the parameter names are different like in the old sequencer we have Loadkey as a parameter.But new scripts are passing BatchNumber.Technically both are same.In order ...

You can export the jobs form the client machine by using following command dscmdexport [/H][/U][/P][/O] project filepath [/V] /H Host name. /U User name. /P Password. /O Omit flag. project Specifies the project name. filepath Specifies the export file name. /V Verbose. Default to false. Note that pr...

I have an input file

Some of the data fields are comp with ASCII values.

Even in unix if i issue head -1 Filename it is giving multiple records not a single record

Thanks

Hi, I am getting the following warning when i tried to reqad fixed width file with ASCII characters Capitationtest..Sequential_File_0.DSLink2: read_fixedwidth() - row 66, column WK_MEMBER_NUMBER, column unexpectedly ended by EOR In the sequential stage if i use line termination none then only i am a...

Here is my C++ code with datastage API functions #ifdef WIN32 #include <windows.h> #endif #include <vector.h> #include <string.h> #include <fstream> #include <iostream> #include <stdio.h> #include <dsapi.h> using namespace std; static void printLogDetail( int indent, /* Number of tabs to indent by *...

Write a batch script and call that script in a routine as a command.It should work.

Thanks
Uma

Some one wrote a basic routine.But when i try to see the code that page is disabled.how can we disable the routine code.is it possible to enable that code again.

Thanks
uma

I used Filter option in the sequential file stage to get the first column in a pipe delimited file. Here is the command awk -F"|" '{print $1}' in the filter option i am not hard coding this command.I am passing this command as a parameter.If i hard code this command and i run the job it is...

Some job s are corrupted.when i click on the job it is giving an error like there is no design information some thing like that.