DSXchange

Hay, request your help on the below question. Thanks! Functionality of Preserve Partition SET is equivalent to explicitly specifying SAME partitioning. If I put Preserve Partition as SET in any upstream stage ex(Transformer, Join stage ), the downstream stages will use the SET partition of upstream ...

Thanks a lot

Hi,

Could any one suggest me how to check whether the value of a column(data type - decimal) is negative/positive.

Thanks,
Sudarsan.

Did anyone tried working in DataStage 7.5 client using Windows 7 ?
Pls confirm, our client want to upgrade Windows.

Hi, My job design looks like this. Sequential file ---> Tfm ----> DB2 stage I am trying to load one record from file to temporary DB2 table. In my target stage, Before loading,I am dropping the table/creating that table again. Dropping and creating the table is happening properly. But loading is not...

Thanks a lot for quick reply.

I will try this and let you know.

Hi, My Job design is like this: DB2----->Tranformer---->Sequential file Actually this job is running fine in production daily(In DataStage 7.5-Windows) Now we are migrating to 8.1-LINUX. In migration, while doing the testing of this job,it is getting aborted with below warning. SQLFetch: Error retri...

chulett wrote:As who said, you done what? Switched to using $PROJDEF? ...

Yes Chulett. Sorry for the confusion.
Using $PROJDEF, issue is solved.

Thanks a lot....Issue solved.(As you said, I have done)

Thanks for quick reply.

Actually,I have added the password like you said only.(In job parameters, from add environment variables, added).

Hi All, I am facing the issue with the enviroment varaibles. In my job, Database password variable is declared as environment variable(encrypted). I have declared the Encrypted password as an environment variable. Initilally I have given one password. At that time my job is working fine. Later on, m...

But I am able to view the content of that file through complex flat file stage except packed decimal columns

Hi ArndW,

I tried to view that file in notepad, but all fileds are showing as some unknown characters.

That's Why I am unable to send you..sorry for not able to provide you the enough information.

Hi, Thanks for Quick reply. PIC clause for the column is: PIC S9(13)V9(5) COMP-3. PIC clause used in the CFF stage:PIC S9(13)V9(5) COMP-3. Sorry, I am unable to provide the Hex values for that columns because I don't have a access to the mainframe system. Mainframe wiil FTP the source file and provi...

Hi All, I am trying to read a COBOL file using Complex flat file stage and write it into a flat file.(Complex FF - Tfm - Seq File) Note: In CFF stage, DataFormat mentioned it as EBCIDIC and Record style as Binary. Source file I have FTPed from Mainframe server in Binary mode. All columns are populat...